Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fixed Decimal
In formatting cells, general automatically enters decimal places. I want to
uncheck 'fixed decimal places' but cannot find that in Excel Options. I am using Excel 2007 and there is no ToolsOptionsEdit. How can I cancel 'fixed decimal places in Excel 2007? I don't want to enter it as text because I have to keep going back to make this correction. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fixed Decimal
Office button, Excel options, Advanced, 2nd checkbox, which says
"Automatically insert a decimal point" (it's been renamed!) Bob Umlas Excel MVP "LoisTO" wrote: In formatting cells, general automatically enters decimal places. I want to uncheck 'fixed decimal places' but cannot find that in Excel Options. I am using Excel 2007 and there is no ToolsOptionsEdit. How can I cancel 'fixed decimal places in Excel 2007? I don't want to enter it as text because I have to keep going back to make this correction. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fixed Decimal
Thank you so much. I had been struggling with this for a week!!
"Bob Umlas, Excel MVP" wrote: Office button, Excel options, Advanced, 2nd checkbox, which says "Automatically insert a decimal point" (it's been renamed!) Bob Umlas Excel MVP "LoisTO" wrote: In formatting cells, general automatically enters decimal places. I want to uncheck 'fixed decimal places' but cannot find that in Excel Options. I am using Excel 2007 and there is no ToolsOptionsEdit. How can I cancel 'fixed decimal places in Excel 2007? I don't want to enter it as text because I have to keep going back to make this correction. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert a decimal into a fixed number? | Excel Discussion (Misc queries) | |||
Format Numbers Without Fixed Decimal | New Users to Excel | |||
Fixed Decimal Question | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
Fixed decimal place | Setting up and Configuration of Excel |