Does someone have an idea as to how to convert note prices in CQG into 64's so as to be able to decimalize them. For 108-055 (108-5.5 32's) the CQG price reads 108055. I figured that I could multiply that by .0001 to arrive at a second cell that would contain a value of 108.055. How can I get Excel to generate an even number of 108 that I could subtract from the 108.055? I tried to use the "format cells" function on the third cell to format the third cell with no decimal places, but when subtracting cell 3 from cell 2, it still gives me zero. Any suggestions? Thanks in advance.
Magyar.
Magyar.
