Forum Discussion

HHDXB's avatar
HHDXB
Copper Contributor
Jul 12, 2021
Solved

US treasury price conversion eg 123'18.5 to 123.536

Hi Friends    I look forward to your email / help Thanks
Formulas and Functions
  • HHDXB's avatar
    HHDXB
    Jul 12, 2021
    Thank you all for your time and input.
    Hans Vogelaar : your setout with reverse calculation was a winner ..... I tested all 100% ..... excellent
    Sergei Baklan : your set out to part of the question ... again worked well ... thank you
HansVogelaar's avatar
HansVogelaar
MVP
Jul 12, 2021

HHDXB 

With 133'18.5 in F3, the formula to convert it to a regular number is

=LEFT(F3,FIND("'",F3)-1)+MID(F3,FIND("'",F3)+1,10)/32

With 133.56 in L3, the formula to convert it to US Treasury notation is

=INT(L3)&"'"&MROUND(MOD(L3,1)*32,0.5)