| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel-Input numeric value in cell, it shows up as 1/100th of entry
I must have some cell formatting setup somewhere or something strange is
going on.... In a cell, I can enter a value of "1". Once I hit return to exit the cell, the value in the cell is shown as "0.01", not "1". This is driving me crazy and I have had miscalculating spreadsheets due to this issue. To re-iterate, when I put a numeric value in a cell, it shows up as 1/100th of the value. Any suggestions to correct this. Darin |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel-Input numeric value in cell, it shows up as 1/100th of entry
Tools Options Edit clear fixed decimal
-- Gary''s Student - gsnu200752 "DarinMelin" wrote: I must have some cell formatting setup somewhere or something strange is going on.... In a cell, I can enter a value of "1". Once I hit return to exit the cell, the value in the cell is shown as "0.01", not "1". This is driving me crazy and I have had miscalculating spreadsheets due to this issue. To re-iterate, when I put a numeric value in a cell, it shows up as 1/100th of the value. Any suggestions to correct this. Darin |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel-Input numeric value in cell, it shows up as 1/100th of entry
ToolsOptionsEdit.
Uncheck "fixed decimal places" Gord Dibben MS Excel MVP On Wed, 31 Oct 2007 10:40:03 -0700, DarinMelin wrote: I must have some cell formatting setup somewhere or something strange is going on.... In a cell, I can enter a value of "1". Once I hit return to exit the cell, the value in the cell is shown as "0.01", not "1". This is driving me crazy and I have had miscalculating spreadsheets due to this issue. To re-iterate, when I put a numeric value in a cell, it shows up as 1/100th of the value. Any suggestions to correct this. Darin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Shows no Color until Data Entry | Excel Discussion (Misc queries) | |||
| How do I restrict entry into a cell to only alpha/numeric? | Excel Worksheet Functions | |||
| How can I enter 1/100th of a second into an Excel cell? | Excel Discussion (Misc queries) | |||
| Numeric cell but shows as string? | Excel Worksheet Functions | |||
| resolving a numeric cell entry for its meaning | Excel Worksheet Functions | |||
Linear Mode
