To stop this automatic simplification, you need to tell Excel what denominator to use. In other words, to keep "4/6" as is, ...

When assigning the Currency number format to the relevant cells, press Ctrl+1 to launch the Format Cells dialog box. There, you can see that negative numbers can be displayed in red, with or ...

Click the dialog box launcher next to Number on the Home tab In the Category list on the left pane, click Fraction In the Type list on the right, click the fraction format type you want to see.

Next, on the Home tab, click the Dialog Box Launcher adjacent to Number. See the screenshot below. Then, in the Format Cells dialog box, in the Category list, click Currency or Accounting.

Set a number format for selected cells, rows or columns. In the Home tab's Number group, click on the angled arrow, or Dialog Box Launcher, beside the Number label.