Format numbres to 32nds

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to compute coupon amount for bond? 3
Operations (add, multiply) on all values ($00.00) in a column? 2
No need to use = sign in formulas 4
cell formate 1
Custom Format - Show 12.5 but not 12.0 (drop .0s) ? 2
Converting "special data" into number in the same column 4
Getting a value out of a Matrix 4
how to stop excel formatting 6

Back
Top