MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Number Formatting


Posted by Dipak on June 04, 2001 6:01 AM

Got a user who is using Office 97 SR2. When she inputs into a cell
a number eg 6000 it appears as 60. Tried formatting
the cell but this has no effect. Every other PC is fine
Also checked the Regional settings and also have reinstalled
Office. Any clues?


Posted by Mark W. on June 04, 2001 6:36 AM

Choose the Tools | Options... menu command, click
on the Edit tab and uncheck the "Fixed decimal"
check box.