# Turn fraction around

#### PabloFer

##### New Member
You did not look at the formula I posted carefully enough... I have the J4 and F4 reversed. I'll show you again...

=F4/J4

Try it to see (still set the cell format to Fraction).
got it thank you, I tried that one before but it doesn't work I need to show the 3/1

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying

#### PabloFer

##### New Member
i'll drop out now as Rick Rothstein has the answer
as I thought the format was TEXT as asked in first post and not formatted is a fraction
the format is not in text is in fraction, I need to keep the formula in my excel

#### Dave Patton

##### Well-known Member
N.B. based just on " The formula is a division =J4/F4 the result is 1/3 the format of cell L4 is in fraction and I need to present 3/1 "
I did not look at the images.

Consider the following:

T202008c.xlsm
FGHIJKL
3310.3333333
431 1/33/1
5
6FormattedFormatted
7as fractionCustom #/1
8
4c
Cell Formulas
RangeFormula
K3:K4K3=J3/F3
L3:L4L3=F3/J3