cell format Anders 28.08.2006 16:54:02 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.

Re: cell format "Bernard Liengme" <bliengme[ at ]stfx.TRUENORTH.ca> 28.08.2006 18:54:03 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" <Anders[ at ]discussions.microsoft.com> wrote in message news:5528C95D-6DF9-44F0-A709-4F1342600B20[ at ]microsoft.com... [Quoted Text] > 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.

RE: cell format CLR 29.08.2006 13:01:02 If your number is a "stock number" or somethine else that you will not have to do math on later, you can prevent the problem by just pre-formatting the cells as TEXT, or typing a leading apostrophe before the number which does the same thing. hth Vaya con Dios, Chuck, CABGx3 "Anders" wrote: [Quoted Text] > 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.