| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
adding hexadecimal numbers
Hi,
As the subject states, how do I add together cells containing hex numbers. I tried the following... A1 contains 0f a2 contains 0f a3 contains = a1 + a2 result #VALUE! I know that it knows the cells could be hex because if I do =hex2dec(a1) in another cell it converts it. Is there anyway in Excel to explicitly set the number type of a cell? Regards, Dave. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding to a column of numbers | Excel Worksheet Functions | |||
| Adding numbers in a single cell | Excel Worksheet Functions | |||
| Excel Adding duplicated numbers together | Excel Discussion (Misc queries) | |||
| Re What is the formula for adding multiple numbers in a cell | Excel Discussion (Misc queries) | |||
| What is the formula for adding mulitple numbers in one excel cell. | Excel Discussion (Misc queries) | |||
Threaded Mode
