entering numbers

[vjc]

Recently I reinstall my Excel on different computer and when I start to
enter data to my existing for years spreadsheets it immidiatly convert
1, 2, 3, etc. to 0.1, 0.2, 0.3 etc. in any sell format - general,
numeric...

How can I fix it?

Thanks,
VJC

 

[Guest]

Try this:

From the Excel main menu:
<tools><options><edit tab>
UN-check: Fixed decimal places

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Don Guillett]

look at tools>options>calculation window