Entering Values in Excel

[enygma]

I have 39 characters in a cell something like this 101010000614021350229003000000000011.10,
when I copy the same in Excel 2007 version it comes out like this 101010000614021000000000000000000000.00

Would someone help me on how to copy it exactly in Excel.

 

[Michael M]

Are they entered as text in the original cell ??

 

[enygma]

I have tried both - text and number still the same problem.
With text - it definitely doesn't show me the entire series and with number as specified it shows something completely different.
I am more concerned with the last two digits (before the decimal point) which never shows properly.

 

[enygma]

I have tried both - text and number still the same problem.
With text - it definitely doesn't show me the entire series and with number as specified it shows something completely different.
I am more concerned with the last two digits (before the decimal point) which never shows properly.