| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does my format keep changing in the cell? | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Conditonal Format with a date format | Excel Discussion (Misc queries) | |||
| Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
| why does currency format change to number format? | Excel Discussion (Misc queries) | |||
Linear Mode
