help!! 1000 appears as 10 in excel

[Help!! 1000 appears as 10 in excel]

When I type 1000 it appears as 10. Can anyone help

 

[Mike H]

Tools|Options|Edit
Un-Check
Fixed decimal places

Mike

 

[Gord Dibben]

Tools>Options>Edit.

Uncheck "fixed decimal places"


Gord Dibben MS Excel MVP