Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet defaults numbers automatically to two decimal places
A colleague of mine has been using excel fine and when inputting numbers they have used the general number format so type "1" and you see "1". He is not aware he has changed anything but even when opening a new file/worksheet if he types in "1" it now defaults to 0.01. How do I get this changed back so that each time he opens a new file /worksheet we dont have to format the individual cells?? Thanks Steve |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet defaults numbers automatically to two decimal places
Try:-
Tools|options|edit Uncheck fixed decimals Mike "Steve Twomey" wrote: A colleague of mine has been using excel fine and when inputting numbers they have used the general number format so type "1" and you see "1". He is not aware he has changed anything but even when opening a new file/worksheet if he types in "1" it now defaults to 0.01. How do I get this changed back so that each time he opens a new file /worksheet we dont have to format the individual cells?? Thanks Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
My numbers format as a number with two decimal places. | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
Adding numbers in a column that have 3 decimal places | Excel Worksheet Functions | |||
Entering numbers with variable decimal places. | Excel Worksheet Functions |