Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to format cells to recognize numbers like 1.1.1? | Excel Discussion (Misc queries) | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Sorting alphanumeric numbers | Excel Discussion (Misc queries) | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) |