Default Cell Format Hijacked to Scientific?

  • Thread starter Thread starter john elf
  • Start date Start date
J

john elf

When I type in the number 12 on a new sheet I get: 1.2E+45
When I change the format to number I get:
1200000000000000000000000000000000000000000000.00

I can't seem to fix this. Help!!

John Elfrank-Dana
Social Studies Teacher/Web Master
Murry Bergtraum High School
(e-mail address removed)
http://www.elfrank.org
 
When I type in the number 12 on a new sheet I get: 1.2E+45
When I change the format to number I get:
1200000000000000000000000000000000000000000000.00
Click to expand...

Check Tools -> Options... -> Edit. You probably have something in the
Fixed Decimal Places box. (-44, by the sounds of it.) Turn off that
option, and you should be OK.
 
Back
Top