CODEWITHSUNDEEP
excelcopy
shadow
shadow

Reputation: 109

Excel, large number copying error

I've got a problem when I'm trying to paste data into excel. I'm downloading data in excel sheet, but in some cells there are numbers of length of 22 digits so excel converts them to scientific notation and after changing the format to text only 15 first digits are correct and else are zeros, Is there any way to convert the numbers from that scientific notation back into exact number. In my opinion no, but maybe there is some way?

Thanks in advance :)

Upvotes: 0

Views: 260

Answers (1)

Vityata
Vityata

Reputation: 43595

Try to format the range of excel as Text, before writing the number there. Then it will be ok. But you will not be able to make any formula calculations:

Public Sub TestMe()

    Dim largeNumber     As String
    largeNumberic = largeNumber

    Range("A1").NumberFormat = "@"
    Range("A1").NumberFormat = largeNumber

End Sub

Upvotes: 0

Related Questions