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.
Sorry, now I also see the worksheet.
Cell formatting needs to be changed.
go to cell (or select cell range), click right mouse button.
Select Format Cells
Change the number format as you wish.Examble, you can make it a standard for all cells.
Ps You could also select the whole worksheet if you tick the corner at the top left.Hope to have helped to solve your problem, if not please give us a short feedback.
Nikolino
I know I don't know anything (Socrates)
NikolinoDE I don't think you understand.
I have already formatted the whole of column A as Accounting, then I entered the formulas that I described in the spreadsheet. Can you please test this by clicking an empty cell in column A, verifying it is accounting format already, and then do +23/2 to match the example.