Thread: cell format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default cell format

In Excel2003, if I enter 123456789123 I get 1.234567E+11 with a cell
formatted to General.
If I format it to Number with 0 decimal places I get 123456789123

Of course, we can only have 15 significant digits because Excel uses the
IEEE convention to store numbers.

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Anders" wrote in message
...
Why when entering a 12 digit number is the last digit is changed to a "0"
when saving? An example would be entering the number 123456789123 would
be
saved as 123456789120. Currently my cell format is general.