Where to get 32nds as a number format in Excell or how to keep f
 

I'm attempting to use functions on integers and fractions; fractions are
32nds; I want them to stay 32nds and NOT round up or down. All I've located
so far are 16ths. This will not work, or would require additional steps to
convert. Isn't there an easier method?

Where to get 32nds as a number format in Excell or how to keep f
 

look here

http://www.mvps.org/dmcritchie/excel/fractex1.htm

Mike

"wiljo" wrote:

I'm attempting to use functions on integers and fractions; fractions are
32nds; I want them to stay 32nds and NOT round up or down. All I've located
so far are 16ths. This will not work, or would require additional steps to
convert. Isn't there an easier method?

Where to get 32nds as a number format in Excell or how to keep f
 

FormatCellsNumberCustom ?/32


Gord Dibben MS Excel MVP

On Sat, 1 Mar 2008 12:59:01 -0800, wiljo
wrote:

I'm attempting to use functions on integers and fractions; fractions are
32nds; I want them to stay 32nds and NOT round up or down. All I've located
so far are 16ths. This will not work, or would require additional steps to
convert. Isn't there an easier method?