| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
my cell entries are automatically being displayed as a decimal?
Hi,
For some reason all my numerical entries are being entered as a decimal. Example: I enter 65 in a cell and it changes to .065 This happens regardless of whether the spreadsheet is new or existing. Anybody know of a fix? Regards Max |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
my cell entries are automatically being displayed as a decimal?
toolsoptionsedit, deselect fixed decimal places
-- Regards, Peo Sjoblom "Max" wrote in message ... Hi, For some reason all my numerical entries are being entered as a decimal. Example: I enter 65 in a cell and it changes to .065 This happens regardless of whether the spreadsheet is new or existing. Anybody know of a fix? Regards Max |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
my cell entries are automatically being displayed as a decimal?
Tools/Options/Edit uncheck the Fixed decimal places checkbox.
In article , Max wrote: Hi, For some reason all my numerical entries are being entered as a decimal. Example: I enter 65 in a cell and it changes to .065 This happens regardless of whether the spreadsheet is new or existing. Anybody know of a fix? Regards Max |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
my cell entries are automatically being displayed as a decimal
Thanks to all.
That did the trick... now if I can figure out how I checked the box to begin with :) "JE McGimpsey" wrote: Tools/Options/Edit uncheck the Fixed decimal places checkbox. In article , Max wrote: Hi, For some reason all my numerical entries are being entered as a decimal. Example: I enter 65 in a cell and it changes to .065 This happens regardless of whether the spreadsheet is new or existing. Anybody know of a fix? Regards Max |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
my cell entries are automatically being displayed as a decimal?
Click TOOLS/OPTIONS and click the EDIT tab. Verify that the Fixed Decimals
checkbox has not been checked on. This automatically punctuates numeric entries with the number of stated decimal positions (default of 2). -- Kevin Backmann "Max" wrote: Hi, For some reason all my numerical entries are being entered as a decimal. Example: I enter 65 in a cell and it changes to .065 This happens regardless of whether the spreadsheet is new or existing. Anybody know of a fix? Regards Max |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
my cell entries are automatically being displayed as a decimal?
Sounds like the Fixed Decimal places option is selected. To deselect it, go to
Tools Options Select the Edit tab and uncheck the Fixed Decimal box if it is checked. -- Elisabeth "Max" wrote: Hi, For some reason all my numerical entries are being entered as a decimal. Example: I enter 65 in a cell and it changes to .065 This happens regardless of whether the spreadsheet is new or existing. Anybody know of a fix? Regards Max |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numbers displayed in the 100th decimal instead on 1,000 | Excel Discussion (Misc queries) | |||
| Automaticallychanging the number of decimal places displayed | Excel Discussion (Misc queries) | |||
| How to extend the no' of displayed entries in a drop down list | Excel Discussion (Misc queries) | |||
| elapsed time displayed as a decimal | Excel Worksheet Functions | |||
| How do I change the number of decimal places displayed in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
