Format numbres to 32nds
=INT(A1/100)+(MOD(A1,100)/32)
Format Custom as "# ?/32" if you like
--
Kind regards,
Niek Otten
"martinkn" wrote in message
...
I download prices from quote service on 30 Treasury Bond futures. They are
downloaded as i.e. 11320, meaning 113 20/32. When using the original
format
in a formula it treats it as a whole number. How can I convert this
original
format to be treated as 32nds.
|