Format numbres to 32nds
Niek ... you're very helpful, thank you very much!
Regards,
Martin
"Niek Otten" wrote:
=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.
|