0

I am currently using custom formatting to get an improper fraction (###/###), however, I will need the integers to be 7 instead of 7/1. How do I achieve both improper fraction OR integer (if it can be simplified)?

improper fraction

3
  • 3
    Perhaps use conditional formatting and test whether the cell value = INT(cell value). Use the result to pick which format to apply.
    – fixer1234
    May 9, 2019 at 5:16
  • As in do a conditional formatting to highlight the integers and manually replace them?
    – Eugene
    May 9, 2019 at 5:19
  • 2
    Not to highlight, just to select the specific formatting you want (integer vs. fraction).
    – fixer1234
    May 9, 2019 at 5:21

1 Answer 1

1

I use : =IF(INT(C2)=C2,TEXT(C2,"#"),TEXT(C2,"###/###")) and drag downwards.

Seems to solve it just fine. Hope it helps. ( :

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .