Hex2dec.... I think you need the maths library pluging thingy Wayne Allen Director E-Stim Systems http://www.e-stim.co.uk wayne@e-stim.co.uk -----Original Message----- From: piclist-bounces@mit.edu [mailto:piclist-bounces@mit.edu] On Behalf Of alan smith Sent: 16 May 2005 23:07 To: Microcontroller discussion list - Public. Subject: [OT] Can this be done in excel? Gathering data...by hand right now at least....a data packet from the PIC, representing the 10bit AD values. Would be nice for something to dump right into excel... 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? __________________________________ Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail -- http://www.piclist.com PIC/SX FAQ & list archive View/change your membership options at http://mailman.mit.edu/mailman/listinfo/piclist -- http://www.piclist.com PIC/SX FAQ & list archive View/change your membership options at http://mailman.mit.edu/mailman/listinfo/piclist