| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
The numbers I enter are changed when I leave the cell
Yes, thank you from me too. Every time I typed in a whole number I ended up
with 2 decimal places, and not being very computer literate was having a tough time of it. I did well to find this site. Cheers, Vonne "Gord Dibben" wrote: ToolsOptionsEdit. Uncheck "fixed decimal places" Gord Dibben MS Excel MVP On Sat, 3 Mar 2007 09:04:08 -0800, kg_ce wrote: Since yesterday if I enter a whole number in a cell, for example 123, when I leave the cell it appears displayed as 0,0123. Why does this happen and how can I change it??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| col of minus numbers changed to plus numbers | Excel Worksheet Functions | |||
| Run formula only if values are enter, otherwise leave blank | Excel Worksheet Functions | |||
| when i enter time in cell it changed, why? | Excel Worksheet Functions | |||
| Why does date come up when I enter numbers in cell/Excel? | Excel Discussion (Misc queries) | |||
| How do I format a cell so that only specific numbers can be enter. | Excel Discussion (Misc queries) | |||
Hybrid Mode
