Format numbres to 32nds
 

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.

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.

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.