| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I changed the "general" number format - I want it back
I must have made some change somewhere. Now when I type in a number in any
cell in excel - new or old, it shows the number with 2 decimal points. IE: type in 2 and I see .02. I've tried all sorts of stuff, but when I format to general I'd get .02, if I select number - no decimal points I get 0, etc. Can someone tell me how I changed the format and how I correct it? Right now I have to remember to type 2. or 345. etc. Thank you -- Raymah |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I changed the "general" number format - I want it back
Tools Options Edit tab uncheck Fixed decimal Places: OK
"Raymah" wrote: I must have made some change somewhere. Now when I type in a number in any cell in excel - new or old, it shows the number with 2 decimal points. IE: type in 2 and I see .02. I've tried all sorts of stuff, but when I format to general I'd get .02, if I select number - no decimal points I get 0, etc. Can someone tell me how I changed the format and how I correct it? Right now I have to remember to type 2. or 345. etc. Thank you -- Raymah |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I changed the "general" number format - I want it back
Thank you, thank you, A thousand times Thank You!
-- Raymah "Teethless mama" wrote: Tools Options Edit tab uncheck Fixed decimal Places: OK "Raymah" wrote: I must have made some change somewhere. Now when I type in a number in any cell in excel - new or old, it shows the number with 2 decimal points. IE: type in 2 and I see .02. I've tried all sorts of stuff, but when I format to general I'd get .02, if I select number - no decimal points I get 0, etc. Can someone tell me how I changed the format and how I correct it? Right now I have to remember to type 2. or 345. etc. Thank you -- Raymah |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Counting number of forwarding and sending back | Excel Discussion (Misc queries) | |||
| number format | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
