ExcelBanter - Strange autoformat occurrence

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Strange autoformat occurrence (https://www.excelbanter.com/excel-discussion-misc-queries/201728-strange-autoformat-occurrence.html)

jojoro50

Strange autoformat occurrence

For some reason, Excel started multiplying all of my cells containing numbers
by a factor of 0.1. So if I want to input "6", I have to type "60". It even
alters cells from older files if I click on a cell with a number. How can I
correct this issue?
Thanks,
Josh

Kevin B

Strange autoformat occurrence

Click TOOLS, OPTIONS and then click the EDIT tab. Locate the FIXED DECIMALS
check box and click to remove the check. Click OK to return to the worksheet
and then resave your file.

--
Kevin Backmann

"jojoro50" wrote:

For some reason, Excel started multiplying all of my cells containing numbers
by a factor of 0.1. So if I want to input "6", I have to type "60". It even
alters cells from older files if I click on a cell with a number. How can I
correct this issue?
Thanks,
Josh

jojoro50

Strange autoformat occurrence

Thank You!!!

"Kevin B" wrote:

Click TOOLS, OPTIONS and then click the EDIT tab. Locate the FIXED DECIMALS
check box and click to remove the check. Click OK to return to the worksheet
and then resave your file.

--
Kevin Backmann

"jojoro50" wrote:

For some reason, Excel started multiplying all of my cells containing numbers
by a factor of 0.1. So if I want to input "6", I have to type "60". It even
alters cells from older files if I click on a cell with a number. How can I
correct this issue?
Thanks,
Josh

All times are GMT +1. The time now is 11:42 PM.