fractions

%3CLINGO-SUB%20id%3D%22lingo-sub-2234528%22%20slang%3D%22en-US%22%3Efractions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2234528%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20express%20something%20(a%20horse's%20height%20in%20traditional%20form)%20as%20units%20of%20'hands'%20%3D%204%20inches.%20Using%20the%20FRACTIONS%20option%20is%20OK%20-%20it%20will%20convert%20decimal%20to%201%2F4%20and%203%2F4%20which%20is%20fine%2C%20but%20I%20would%20like%20Excel%20to%20reduce%20the%202%2F4%20to%201%2F2.%20I%20tried%20CUSTOM%20but%20using%20the%20'2'%20units%20only%20gives%200%2C%201%2F2%2C%20or%201.%20Any%20suggestions%2C%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2234528%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I need to express something (a horse's height in traditional form) as units of 'hands' = 4 inches. Using the FRACTIONS option is OK - it will convert decimal to 1/4 and 3/4 which is fine, but I would like Excel to reduce the 2/4 to 1/2. I tried CUSTOM but using the '2' units only gives 0, 1/2, or 1. Any suggestions, please?

 

2 Replies

@duncanmc1941 

Does this do what you want?

S0240.png

@Hans Vogelaar 

Hi Hans, thanks, that works, with the conversion from cm to inch added as I was working from cm. Cheers