| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 dividing by 100 when it's not supposed to.
Excel 2007 has started automatically dividing new values I type in to cells
by 100. I can't tell if it's actually changing the value, or just the presentation. I have reformatted to General and number and changed decimals allowed. Nothing changes it. I have automatically calculate percentages turned off. Though I suppose turning that on could solve the problem, I prefer to have the actual values presented. If I format the cell as text ahead of time, it will keep the proper value. If I reformat the wrong value to text, it stays wrong. Please help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 dividing by 100 when it's not supposed to.
I finally searched for "100" and found the answer in the forum archives.
Turns out I had fixed decimals on. Thanks everyone! "efhw" wrote: Excel 2007 has started automatically dividing new values I type in to cells by 100. I can't tell if it's actually changing the value, or just the presentation. I have reformatted to General and number and changed decimals allowed. Nothing changes it. I have automatically calculate percentages turned off. Though I suppose turning that on could solve the problem, I prefer to have the actual values presented. If I format the cell as text ahead of time, it will keep the proper value. If I reformat the wrong value to text, it stays wrong. Please help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is this function supposed to work? | Excel Worksheet Functions | |||
| Chart filling in dates that aren't supposed to be there | Charts and Charting in Excel | |||
| Excel is dividing my entries...why?? | Excel Discussion (Misc queries) | |||
| Excel If statement that is supposed to return a "" instead returns a 0 | Excel Worksheet Functions | |||
| When I publish a web page that's supposed to be interactave it be. | Excel Discussion (Misc queries) | |||
Linear Mode
