Ed,

In B1, enter the formula =HEX2DEC(A1) . Then, select B1 and
downwards as far as you want to go, and press Ctrl+D.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Ed G" wrote in message
...
Hi there!

This is way beyond my maths understanding.

I'm trying to use Excel to convert HexDecimal to Decimal.
Ideally, I'd like to be able to key in the HexDecimal value in
cell A1 and for A2 to automatically convert it to Decimal. This
to then run all the way down 64 rows converting values in the
same manner from Column 1 to Column 2.

Can you do it with simple function commands?

Anybody any ideas?... all gratefully received.

Many thanks

Ed G