| 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! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
1 entered in cell comes up as 0.0000000001
have a look at .......tools.... options....edit......and uncheck fixed
decimal places -- Greetings from New Zealand "Breezy" wrote in message ... 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! |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
1 entered in cell comes up as 0.0000000001
Thanks!
"Bill Kuunders" wrote: have a look at .......tools.... options....edit......and uncheck fixed decimal places -- Greetings from New Zealand "Breezy" wrote in message ... 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! |
| Reply |
| 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 | |||
Linear Mode
