1 is converted in 0.001 in all excell files

[Guest]

in my all exell files: old and new: when i put any numeric value and press
enter it is displayed in fraction . For eg. 1 is dispalyed as 0.001
I want to remove this coversion but dont know hoe.

 

[Max]

Click Tools > Options > Edit tab
Uncheck "Fixed decimal" > OK
(It's probably checked for 3 d.p.)

 

[Bob Phillips]

see response to previous question.

--

HTH

RP
(remove nothere from the email address if mailing direct)