entering numbers
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 |
entering numbers
Try this:
From the Excel main menu: <tools<options<edit tab UN-check: Fixed decimal places Does that help? *********** Regards, Ron XL2002, WinXP "vjc" wrote: 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 |
entering numbers
look at toolsoptionscalculation window
-- Don Guillett SalesAid Software "vjc" wrote in message oups.com... 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 |
All times are GMT +1. The time now is 03:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com