Special fractions

H

Hance

Need help getting decimal fractions to display without rounding. Example: 21.25/32. The # ??/32 custom format does not work. Any thoughts?
 
H

Hance

I need to clarify upon reflection. I want to enter a number like 99 +21.25/32 and have it display in one cell just like that (the + could go away) and be able to use it in a calculation in others.
 
A

AlfD

Hi!

I thought I saw a decimal point (period) between the 21 and the 25. Tr
21 25/32 (no period). Looks like this in the cell and looks lik
21.78125 in the formula bar. That help?

Al
 
Top