| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
integers entered are converted into decimal places e.g. 1 = 0.01
I'm using Excel to do a darts team's scores and averages. When I enter
integers, they are converted into 0 plus two decimal places, e.g 1 appears as 0.01, 12 appears as 0.12 etc. If I enter e.g. 1.22 or 0.12 its OK. I can only get the right entry by e.g. 100 which appears as 1. The averages are calculated and displayed OK with 2 decimal places. I've tried re-installing Office but no joy. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
integers entered are converted into decimal places e.g. 1 = 0.01
Tools/Options/Edit. Uncheck the Fixed Decimals checkbox.
In article , Alan H <Alan wrote: I'm using Excel to do a darts team's scores and averages. When I enter integers, they are converted into 0 plus two decimal places, e.g 1 appears as 0.01, 12 appears as 0.12 etc. If I enter e.g. 1.22 or 0.12 its OK. I can only get the right entry by e.g. 100 which appears as 1. The averages are calculated and displayed OK with 2 decimal places. I've tried re-installing Office but no joy. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimal Places | Excel Discussion (Misc queries) | |||
| Unwanted decimal places when entering integers | Excel Discussion (Misc queries) | |||
| Numbers entered are being automatically converted ? | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| decimal places | Excel Discussion (Misc queries) | |||
Linear Mode
