| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I type in 3, I get .003 after hitting enter. All .xls files.
Every .xls file I open or create, this occurs. If I type in a number & hit
enter, that number divided by 1000 appears. This does not appear to be related to formatting or a formula, but rather some global "setup" or "options" feature in my desktop. In my office, no one else experiences this & our IT guys have no answer for me. I can get the number entered correctly by typing ie. 3.0 to get 3. But if I type 3, I'll get .003 . If I double-click into a cell which contains 3, then <enter I'll get .003 . This could actually be useful at times... I would like to know how to turn this ON & OFF. Any idea? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If I type in 3, I get .003 after hitting enter. All .xls files.
Goto ToolsOptions and on the Edit tab there is a checkbox for Fixed
Decimal. Uncheck that box. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "Stu" wrote in message ... Every .xls file I open or create, this occurs. If I type in a number & hit enter, that number divided by 1000 appears. This does not appear to be related to formatting or a formula, but rather some global "setup" or "options" feature in my desktop. In my office, no one else experiences this & our IT guys have no answer for me. I can get the number entered correctly by typing ie. 3.0 to get 3. But if I type 3, I'll get .003 . If I double-click into a cell which contains 3, then <enter I'll get .003 . This could actually be useful at times... I would like to know how to turn this ON & OFF. Any idea? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If I type in 3, I get .003 after hitting enter. All .xls files.
"Stu" wrote in message
... Every .xls file I open or create, this occurs. If I type in a number & hit enter, that number divided by 1000 appears. This does not appear to be related to formatting or a formula, but rather some global "setup" or "options" feature in my desktop. In my office, no one else experiences this & our IT guys have no answer for me. I can get the number entered correctly by typing ie. 3.0 to get 3. But if I type 3, I'll get .003 . If I double-click into a cell which contains 3, then <enter I'll get .003 . This could actually be useful at times... I would like to know how to turn this ON & OFF. Any idea? Tools/ Options/ Edit: Unset "Fixed decimal places" -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| wHY WON'T MOST DOWNLOADED .XLS FILES OPEN IN VERSION 5.0 ? | Excel Discussion (Misc queries) | |||
| How do I read .xls files with Windows XP Home Edition? | Excel Discussion (Misc queries) | |||
| Cannot access read-only documents. | Excel Discussion (Misc queries) | |||
| Importing .txt data files increases .xls file size | Excel Discussion (Misc queries) | |||
| I'm getting files saved with names like 48A52100 with no .xls f. | Excel Discussion (Misc queries) | |||
Linear Mode
