Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple HexDecimal to Decimal Converter
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple HexDecimal to Decimal Converter
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple HexDecimal to Decimal Converter
Thanks for your speedy response.
I've keyed this into the the cell A2, but Excel chucks up a #NAME? error. I'm using Excel 2000, in case that is relevant What am I doing wrong? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple HexDecimal to Decimal Converter
The HEX2DEC and DEC2HEX functions are part of the Analysis Tool
Pack add-in, so you must have this add-in loaeded in order to use the functions. In Excel, go to the Tools menu, choose Add-Ins, and put a check next to "Analysis Tool Pak". You can leave "Analysis Tool Pak - VBA" unchecked. "Ed G" wrote in message ... Thanks for your speedy response.. I've keyed this into the the cell A2, but Excel chucks up a #NAME? error. I'm using Excel 2000, in case that is relevant. What am I doing wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
simple currency addition in cell without having to enter decimal | Excel Worksheet Functions | |||
Batch converting CSV files from comma-decimal to period-decimal | Excel Discussion (Misc queries) | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) |