| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading decimal and zeros in formating numbers
All the sudden my worksheet started adding a decimal and 10 zeros to my
number entries. I've tried to format the cell/column again, but it won't change. What have I done and how do I fix it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Leading decimal and zeros in formating numbers
Maybe,
Tools|Options|edit and un-check fixed decimal places Mike "DLJames" wrote: All the sudden my worksheet started adding a decimal and 10 zeros to my number entries. I've tried to format the cell/column again, but it won't change. What have I done and how do I fix it? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Leading decimal and zeros in formating numbers
That fixed it! Thank you! Now the only question left, is how did that box
get checked in the first place? One minute I could enter just fine and then later it was all crazy with zeros! Thank you again for your help. Sanity is restored! "Mike H" wrote: Maybe, Tools|Options|edit and un-check fixed decimal places Mike "DLJames" wrote: All the sudden my worksheet started adding a decimal and 10 zeros to my number entries. I've tried to format the cell/column again, but it won't change. What have I done and how do I fix it? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Leading decimal and zeros in formating numbers
Two ways to get that enabled.
1. User checked it. 2. VBA code checked it. Gord Dibben MS Excel MVP On Fri, 30 Nov 2007 09:56:02 -0800, DLJames .(donotspam) wrote: That fixed it! Thank you! Now the only question left, is how did that box get checked in the first place? One minute I could enter just fine and then later it was all crazy with zeros! Thank you again for your help. Sanity is restored! "Mike H" wrote: Maybe, Tools|Options|edit and un-check fixed decimal places Mike "DLJames" wrote: All the sudden my worksheet started adding a decimal and 10 zeros to my number entries. I've tried to format the cell/column again, but it won't change. What have I done and how do I fix it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you delete leading zeros from numbers? | Excel Discussion (Misc queries) | |||
| Removing leading zeros from a group of numbers | Excel Discussion (Misc queries) | |||
| Leading Zeros and decimal points | Excel Worksheet Functions | |||
| Social Security Numbers & Leading Zeros | Excel Discussion (Misc queries) | |||
| sort numbers leading zeros | Excel Discussion (Misc queries) | |||
Linear Mode
