How to turn off auto-formating of numbers into scientific number format.

[Tom Felts]

This has to be one of the most annoying things I have ever seen come out of
the Redmond collective.

If you import numbers into an excel 2003 spreadsheet, like 2003E152, it will
automatically format it in scientific notation.
I have read http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q214233


I refuse to accept this as a "feature". I would like to know how to turn it
off completely, so it never does the conversion.

Thanks,

twf

 

[Harald Staff]

Hi

Can't be done in general. You have to do adjust the way you "import numbers
into".

HTH. Best wishes Harald

 

[Tom Felts]

I figured it out. I switched to Open Office...


thanks,

twf

 

[Harald Staff]

LOL. I originally also wrote something like "if you refuse to accept
features of a spesific program, then you should look for another one that
you're more happy with" -but deleted it before posting, it looked too grumpy
in writing. Glad you found a solution

Best wishes Harald