TheMissingPoint
New Member
- Joined
- Sep 20, 2022
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
Hi,
New member. Office 2016.
I have a problem with existing and new spreadsheets (95% usage is for currency). I have the "Automatically insert decimal point" turned on. My custom settings are in place - [Red]#,##0.00;[Blue]"-("#,##0.00). I have checked all my Regional settings to make sure nothing has changed. Since about the 13th of September, every time I enter figures, the entries ignore the settings - what should be 16.00 comes up as 0.16 or -(16.00) as -(0.16).
I suspect this has something to with Windows 10 itself. But I am getting desperate, as my searches on the internet have not found any reports of this error.
Any suggestions greatly appreciated.
New member. Office 2016.
I have a problem with existing and new spreadsheets (95% usage is for currency). I have the "Automatically insert decimal point" turned on. My custom settings are in place - [Red]#,##0.00;[Blue]"-("#,##0.00). I have checked all my Regional settings to make sure nothing has changed. Since about the 13th of September, every time I enter figures, the entries ignore the settings - what should be 16.00 comes up as 0.16 or -(16.00) as -(0.16).
I suspect this has something to with Windows 10 itself. But I am getting desperate, as my searches on the internet have not found any reports of this error.
Any suggestions greatly appreciated.