Special Format

[thmehr]

HI, I have a formula that is a fraction and I want to keep in a fraction format. Example c2=a1/b2 I want excel display this as a fraction. I have tried even creating my own custom format, but excel keeps changing the fraction. How can I display this fraction without excel change the ratio numbers. Example 73/27 comes out in excel 175/64. Thanks for your help.

[ajm123456789]

in format cells go to custom. choose ??/??. if its not there, create it.
That worked for me

[icestationzbra]

can you share a sample data set, including the formula that spits out the fractions?

[JieJenn]

Try =TEXT(A1,"##") &TEXT("/","Text") & TEXT(B2,"##")

[thmehr]

in format cells go to custom. choose ??/??. if its not there, create it.
That worked for me

I tried created that one and excel was still messing with the numbers.
Thanks for your help
Ted

[thmehr]

can you share a sample data set, including the formula that spits out the fractions?

HI I posted a sample sheet. It is in my first post. Thanks for your help
Ted

[thmehr]

Try =TEXT(A1,"##") &TEXT("/","Text") & TEXT(B2,"##")

Is this a formula or a format? If this is a formula, will it be treated as text or as number?

Thanks for your help
Ted

[JieJenn]

Formula. Give it a try first.

[ajm123456789]

your problem is that 230/100 is 2.3
while 70/30 is 2.33333
By changing the format to your preferred you're actually changing the answer.

[thmehr]

i am just need to round off the number?

[thmehr]

Ok, I used the Round function and now I get 7/3. Excel is still simplify the fraction down.

[icestationzbra]

@thmehr, are you going to have to use the resulting fraction in a calculation somewhere else? if the answer is an emphatic NO, then you can use @jiejinn's formula thus in cell E4:

Please Login or Register  to view this content.

[thmehr]

Hi, In the end, I used your formula. Thanks Ted