Forum Discussion
Dustin935
Aug 09, 2020Copper Contributor
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...
PeterBartholomew1
Aug 09, 2020Silver Contributor
For what it is worth, I do not experience this. If the input starts with an '=' or a '+' it remains as a formula and picks up the formatting from the cell. Without '=' or '+' it is taken to be a fraction and formatted accordingly.
I am using Microsoft 365 beta channel.