Default Cell Format Hijacked to Scientific?

[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

 

[Peo Sjoblom]

Look under tools>options>edit and uncheck fixed decimal places

 

[Hank Scorpio]

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

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.

 

[John Elfrank-Dana]

Hank and Peo,

Thanks you both very much!!!! That was it.