| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
problems entering in numbers
When i try to enter in 12 into a cell i actually get 0.12
i have tried to adjust using the format cells option but to no avail. Is there a fix or am i missing or overlooking something! Thanks Ian |
|
#2
|
|||
|
|||
|
You need to use Tools | Options; open the Edit tab; uncheck the Fixed
Decimals box best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Ian" wrote in message ... When i try to enter in 12 into a cell i actually get 0.12 i have tried to adjust using the format cells option but to no avail. Is there a fix or am i missing or overlooking something! Thanks Ian |
|
#3
|
|||
|
|||
|
Hi Ian,
Tools | Options | Edit | Deselect "Fixed Decimal" --- Regards, Norman "Ian" wrote in message ... When i try to enter in 12 into a cell i actually get 0.12 i have tried to adjust using the format cells option but to no avail. Is there a fix or am i missing or overlooking something! Thanks Ian |
|
#4
|
|||
|
|||
|
Toolsoptionsedit and uncheck fixed decimal places
Regards, Peo Sjoblom "Ian" wrote: When i try to enter in 12 into a cell i actually get 0.12 i have tried to adjust using the format cells option but to no avail. Is there a fix or am i missing or overlooking something! Thanks Ian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
| Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Linear Mode
