| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel changes numbers
Strange problem popped up today - independent of the working in use - a new
blank, new from a template, or previous sheet - every whole number is replaced by 1/100 of that number - ie, 1 is replaced by 0.01, regardless of cell format. This is isolated to my computer. Excel has been removed/reinstalled, updated, run excel.exe /unregserver & then /regserver - no change. There are no hidden macros. Aaargh! Hard to get any work done! Please help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel changes numbers
Tools|Options|Edit tab|uncheck fixed decimal places.
Lots of accounting type people like this to make data entry easier. (Normal people <vbg hate it!) Neal Henzler wrote: Strange problem popped up today - independent of the working in use - a new blank, new from a template, or previous sheet - every whole number is replaced by 1/100 of that number - ie, 1 is replaced by 0.01, regardless of cell format. This is isolated to my computer. Excel has been removed/reinstalled, updated, run excel.exe /unregserver & then /regserver - no change. There are no hidden macros. Aaargh! Hard to get any work done! Please help! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel changes numbers
I just wanted to add that this just started happening to my excel
spreadsheets today too. Was there some kind of windows download that changed the default of this box to become checked? I don't believe mine was ever checked before. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel changes numbers
Maybe.
You could have downloaded a workbook/addin that had a macro that changed this setting. I've never seen it change for me in any automatic fashion, but there have been a load of people who could never explain how that setting got toggled. I'll count you in that group! yakalo wrote: I just wanted to add that this just started happening to my excel spreadsheets today too. Was there some kind of windows download that changed the default of this box to become checked? I don't believe mine was ever checked before. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change the way numbers are displayed in Excel 2003 SP2 | Excel Discussion (Misc queries) | |||
| How to switch negative numbers to positive numbers in Excel ? | Excel Worksheet Functions | |||
| Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Linear Mode
