alan smith wrote: > So ive got it left justified, high byte being the upper 8 bits and low > byte upper two bits being the lowest two bits...that made sense right? > > Say we have the value 0x79C0, I want to have excel strip off the lower 6 > bits and convert to decimal. And so I get the final result of 487. Is > there a simple way in excel to do this? This is not quite clear, to me at least. All the others seemed to think that you are sending the /string/ "0x79C0" to Excel (or typing this string). Is that what you are doing? How and in what form do you put the data into Excel? Gerhard -- http://www.piclist.com PIC/SX FAQ & list archive View/change your membership options at http://mailman.mit.edu/mailman/listinfo/piclist