formating problem

S

saziz

Hi,
I am using Excel 2000 my problem is cell formating, I am typing
number in a cell say 5 at it appears as 0.05 I have tried going an
formating the cell as number it does not change, I tried formatting a
general it did not change. I also tried going into options in tool
but I don't know what has changed so I can correct it. Any idea?
Thanks
Sazi
 
C

ccr

Sounds like you have Fixed Decimal places turned on. Go
to Tools >> Options >> Edit. Uncheck the box for Fixed
Decimals.

ccr
 
G

Gord Dibben

You were warm.

Tools>Options>Edit. Uncheck "Fixed decimal" box.

Gord Dibben Excel MVP
 
Top