Forum Discussion
Accounting format changing to fraction
I have Excel 2013 and latest update. I have been experiencing a strange issue that can be replicated in office 365 excel too. Blank sheet, Select a cell and change the formatting to accounting...
Dustin935 For what its worth... this is now happening to me. Wild, given I've spent a decade heavily using Excel and never run into this before. Really maddening.
Last try
File> Options
[Is the tick next to "Insert decimal point automatically" not set anyway?]
Decimal places can be specified in "Format cells".
Note: In order to ensure that the changes in the control panel are adopted by Excel and are up to date, you should restart Excel.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
- What is entered under File - Options - Advanced for the decimal separator?
Please also check whether the check mark next to "Use separator from operating system" is ticked, and below that next to decimal separator and thousand separator.
Cheers
Nikolino