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...
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.
Please take a look at this file.
Send you my last / notes in the inserted file.
If this doesn't help either, I really don't know how I can help you. The translation probably doesn't come across as you want me to understand.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.
