Home |
Search |
Today's Posts |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
How to convert a decimal number to a non-decimal number? | Excel Worksheet Functions | |||
Function to convert feet and inchs into decimal equivalents | Excel Worksheet Functions | |||
how to convert total hours (HH:MM) into decimal number | Excel Worksheet Functions | |||
How to convert decimal values (dd.dddddd) to degrees/minutes/seco. | Excel Worksheet Functions |