Re: [PDEV] Excel and Hex
Thanks, Ian and Don, just what I was after. It never ceases to amaze me just how useful these forums are. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteldevforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PDEV] Excel and Hex
Hi Thomas, Install the Analysis toolpak and use DEC2HEX. Cheers, Thomas wrote: > Does anyone know if it is possible to format an excel cell (MS Office 2000 > not Protels' version) to show an integer in hexadecimal format - and if so, > how? > > Thanks, > > Tom. -- Don Mayfield Anglo-Australian Observatory 167 Vimiera Rd Eastwood NSW 2122 Australia Ph. 61-2-9372-4836 Fax. 61-2-9372-4880 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteldevforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PDEV] Excel and Hex
On 10:34 AM 22/03/2002 +1100, Thomas said: >Does anyone know if it is possible to format an excel cell (MS Office 2000 >not Protels' version) to show an integer in hexadecimal format - and if so, >how? > >Thanks, > >Tom. Hex2Dec, Dec2Hex - only available if you have the Analysis Toolpack add-in loaded (Tools|Add-ins). There are also Bin2Dec, Hex2bin etc etc etc Ian Wilson * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteldevforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
[PDEV] Excel and Hex
Does anyone know if it is possible to format an excel cell (MS Office 2000 not Protels' version) to show an integer in hexadecimal format - and if so, how? Thanks, Tom. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteldevforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *