fractions

[Ninbu]

Help
I have an excel cell, where the format is fractions (Right click ->number -) fraction)

Excel automatically rounds 4/110 to 2/55.
how do I stop it

If you have answered you save my day

 

[RSXchin]

that's not rounding. It's called simplifying.

you might want to show it as text instead of a number.

 

[mikerickson]

If you want the denominator to always be 110, you could use the custom format # ?/110

 

[Ninbu]

It does not help
The cell is a calculation cell, where imputed come from many different sheets.

=('2'!J9+'3'!J9+'4'!J9+'Indtast her'!J9)/('2'!J10+'3'!J10+'4'!J10+'Indtast her'!J10)

=(0+1+2+2)/ (10+50+50+0). I can not format it to text

I must show the entire number 4/110, but but excel shortening fraction to 4/55

hope you can help

 

[Ninbu]

Sorry
=(0+0+2+2)/ (10+50+50+0) = 4/110

 

[RSXchin]

=('2'!J9+'3'!J9+'4'!J9+'Indtast her'!J9) & "/" & ('2'!J10+'3'!J10+'4'!J10+'Indtast her'!J10

 

[Ninbu]

thank you so much, you save my day