If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
hex to decimal convert
Hi
Is it possible to have a formula convert a string of hex values to decimal numbers? say put hex values, in column A1- A8 and as soon as you put in values in each cell Dec numbers will apear adjcent B1-B8? Hex ie: C0, 7E, 4D, F4, 1E, 4F, 55, 7D and give the answers in Dec ie: 192, 126, 077, 244, 030, 079, 085, 125 I hope this is clear, I am quite new to Excel TIA |
#2
|
|||
|
|||
On Sun, 16 Jan 2005 19:31:32 GMT, "Nadia" wrote:
Hi Is it possible to have a formula convert a string of hex values to decimal numbers? say put hex values, in column A1- A8 and as soon as you put in values in each cell Dec numbers will apear adjcent B1-B8? Hex ie: C0, 7E, 4D, F4, 1E, 4F, 55, 7D and give the answers in Dec ie: 192, 126, 077, 244, 030, 079, 085, 125 I hope this is clear, I am quite new to Excel TIA Look at HEX2DEC in Excel Help. Briefly, in B1 you would put the formula =IF(A1="","",hex2dec(A1)) and copy/drag it down. --ron |
#3
|
|||
|
|||
Use
=HEX2DEC(A1) HEX2DEC is an Analysis Toolpak Add-in function (Tools/Add-ins... check the appropriate checkbox). In article , "Nadia" wrote: Hi Is it possible to have a formula convert a string of hex values to decimal numbers? say put hex values, in column A1- A8 and as soon as you put in values in each cell Dec numbers will apear adjcent B1-B8? Hex ie: C0, 7E, 4D, F4, 1E, 4F, 55, 7D and give the answers in Dec ie: 192, 126, 077, 244, 030, 079, 085, 125 I hope this is clear, I am quite new to Excel TIA |
#4
|
|||
|
|||
Thank you Ron,
It works fine Nadia "Ron Rosenfeld" wrote in message ... On Sun, 16 Jan 2005 19:31:32 GMT, "Nadia" wrote: Hi Is it possible to have a formula convert a string of hex values to decimal numbers? say put hex values, in column A1- A8 and as soon as you put in values in each cell Dec numbers will apear adjcent B1-B8? Hex ie: C0, 7E, 4D, F4, 1E, 4F, 55, 7D and give the answers in Dec ie: 192, 126, 077, 244, 030, 079, 085, 125 I hope this is clear, I am quite new to Excel TIA Look at HEX2DEC in Excel Help. Briefly, in B1 you would put the formula =IF(A1="","",hex2dec(A1)) and copy/drag it down. --ron |
#5
|
|||
|
|||
On Sun, 16 Jan 2005 20:24:25 GMT, "Nadia" wrote:
Thank you Ron, It works fine Nadia You're welcome. Glad to help. --ron |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to measure the distance between two lat and long points | A new kind of measurement | Running & Setting Up Queries | 6 | January 14th, 2005 04:45 PM |
How to convert a decimal number to a non-decimal number? | snickers22 | Worksheet Functions | 4 | January 13th, 2005 10:04 PM |
Can Excel convert from hex to decimal and vice versa? | LordJezo | General Discussion | 2 | July 7th, 2004 08:36 PM |
Convert decimal number into hours and minutes | Gabriel Maraqa | Worksheet Functions | 2 | March 8th, 2004 04:50 PM |