Converting imported txt cells to number remove 4 last characters.

[metropol]

I have tried different solutions regarding converting importet TXT cells to Number Cells (copy blank cell, paste special with Multiply etc) but nothing seems to work

1. I have exported a report as a csv document. Asked the report to export this field as NUMBER field.
2. Using import wizard and choose NUMBER for this column
3. Number is imported as 707057500064619706. Green indicator tell me that "this numbers is stored as text". I have an option to convert to number. I accept
4. Excel produce 7,07058E+17
5. I choose format cell and NUMBER.
6. Excel produce 707057500064614000,00

The last 4 characters are changed.

Any ideas?

 

[VoG]

Excel can only handle numbers with up to 15 digits. Above that length the number will be truncated.

 

[metropol]

Thx for quick reply. That I was not aware of....Any workarounds?

Maybe a solution to use =left(a1, 18) in column to the left......

 

[VoG]

If you don't convert the number stored as text you can have 18 (or more) characters but you won't be able to perform calculations.

 

[metropol]

Ok. Thank you