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...
Click on the Excel button at the top left, then in the dialog at the bottom right on Excel options.
In the dialog that follows, select formulas on the left.
Then on the right below Working with formulas, remove the check mark for R1C1 reference type.
I'm not an Office 365 expert or as far as I know, since Office 2007 you can correct this ... or should be corrected so.
In the dialog that follows, select formulas on the left.
Then on the right below Working with formulas, remove the check mark for R1C1 reference type.
I'm not an Office 365 expert or as far as I know, since Office 2007 you can correct this ... or should be corrected so.
If you find this helpful, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.
Nikolino
I know I don't know anything (Socrates)
NikolinoDE This box (R1C1) isn't checked for me.