Number has too many digit and it become "000" at the end.

[CE LIM]

I downloaded the bank number into excel 2007. It becomes "0000" at the end, which is not. How to avoid excel convert the number to 0000?

 

[bobhc]

Good day and welcome to the forum CE LIM if you have not already done so, please read this link as it will help you in the use of the forum.

http://chandoo.org/forum/threads/new-users-please-read.294/

You say too many digits, but do not say how many, there is a limit on the display of digits in Excel.


.

 

[NARAYANK991]

Hi ,

See if this helps.

http://support.microsoft.com/kb/269370

Narayan