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 |
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 |