auto decimal

[oykeong]

When I punch in 1978, I expect the display to be 1,978.00 but it comes out
to be 19.78. Anyone knows how to solve this? TQVM.

 

[Dave Peterson]

In xl2003:
Tools|Options|Edit Tab|Uncheck Fixed Decimal

 

[oykeong]

Dave,

Thanks alot!!!

In xl2003:
Tools|Options|Edit Tab|Uncheck Fixed Decimal