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...
One cause of the error could probably be that you accidentally changed the standard format ...
Open the format templates in the Start tab. Then right-click the Standard style and select Modify from the context menu.
It's just a chance, without a workbook you can only guess.
It is always more sensible to upload a file (without sensitive data) so that we can understand the problem. This enables us to offer you a solution that is quicker and more specific, which in turn could be available to you more quickly.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
* Beware of scammers posting fake support numbers here.
Here is a quick example of what I'm experiencing
Strange that this book is happy with =23/2 but +23/2 is causing the issue. Normally it's both that are doing it.
See if you get the same issues with this.
