Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
1 entered in cell comes up as 0.0000000001
I have checked the cell format properties and set it to general and then
number w/ 2 decimal, the only way i can get 1 to stay as a 1 is to change the cell properties to text. Why is it doing this? it just started today and i dont know what i did. thansk! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change color of cell when different cell has data entered | Excel Discussion (Misc queries) | |||
Controlling which cell you go to when Tab is entered | Excel Discussion (Misc queries) | |||
formulas appear in cell as entered.. | Excel Worksheet Functions | |||
cell that only a certain number may be entered | Excel Worksheet Functions | |||
Last cell entered | Excel Worksheet Functions |