S
SC
I have never been to this newsgroup and I am astounded by the
plethra of post on here. I look forward to using this resource.
I have a task I have not been able to complete.
I have an excel spread sheet that contains several colums. I would
say each colum has at least 1000 lines. There is one particular
column that has numbers in HEXADECIMAL format. Due to the enormous
amount of data contained in this column it is not feasible for me to
take each number and manually conver them to DECIMAL.
I want to know if there is a formula I can plug in for the whole
column that when I envoke it ...it will convert each line in that
column from hex to decimal. I have seen the hex2dec formaul listed
in the program and have been able to run it however it only does one
line.
Being a newbie I am requesting step by step instructions (if possible)
of how to achieve this result.
I appreciate it and thanks so much.
SC
Raleigh, N.C.
scederas<at>gmail.com
plethra of post on here. I look forward to using this resource.
I have a task I have not been able to complete.
I have an excel spread sheet that contains several colums. I would
say each colum has at least 1000 lines. There is one particular
column that has numbers in HEXADECIMAL format. Due to the enormous
amount of data contained in this column it is not feasible for me to
take each number and manually conver them to DECIMAL.
I want to know if there is a formula I can plug in for the whole
column that when I envoke it ...it will convert each line in that
column from hex to decimal. I have seen the hex2dec formaul listed
in the program and have been able to run it however it only does one
line.
Being a newbie I am requesting step by step instructions (if possible)
of how to achieve this result.
I appreciate it and thanks so much.
SC
Raleigh, N.C.
scederas<at>gmail.com