|
| 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
January 16th, 2005, 07:31 PM
|
|||
|
|||
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
January 16th, 2005, 07:39 PM
|
|||
|
|||
|
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
January 16th, 2005, 07:43 PM
|
|||
|
|||
|
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
January 16th, 2005, 08:24 PM
|
|||
|
|||
|
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
January 16th, 2005, 10:36 PM
|
|||
|
|||
|
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 |
Linear Mode
