entering numbers

V

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
 
R

Ron Coderre

Try this:

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

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

XL2002, WinXP
 
Top