ExcelBanter - Stop Excel from converting integers into decimals?

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

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - Stop Excel from converting integers into decimals? (https://www.excelbanter.com/setting-up-configuration-excel/142179-stop-excel-converting-integers-into-decimals.html)

mcwilljg

Stop Excel from converting integers into decimals?

Excel has suddenly begun converting all numerical entries to 2 decimal place
numbers. Example 123 -1.23 In order to get 123 one must entr "123." or
12300" This seems to be stuck in some accounting or business formatting. It
just started and I can't change it. Any help?

Niek Otten

Stop Excel from converting integers into decimals?

ToolsOptionsEdit tab, Uncheck Fixed Decimal

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"mcwilljg" wrote in message ...
| Excel has suddenly begun converting all numerical entries to 2 decimal place
| numbers. Example 123 -1.23 In order to get 123 one must entr "123." or
| 12300" This seems to be stuck in some accounting or business formatting. It
| just started and I can't change it. Any help?

All times are GMT +1. The time now is 12:50 PM.