# Formula for Decimal to Hex Conversion considering A,B,C

This is a discussion on Formula for Decimal to Hex Conversion considering A,B,C within the Excel Questions forums, part of the Question Forums category; Please guide me how i can write a formula for excel sheet which can do the following:- Converts a Decimal ...

1. Please guide me how i can write a formula for excel sheet which can do the following:-

Converts a Decimal Number into HEX Number system considering A,B,C,D,E,F characters.

Like when i place a value 255 in one of the cell of excel sheet which is in decimal it converts it into HEX number system and present the value in other sheet,

So please provide me the formula for :-

1) Decimal to HEX conversion

2) HEx to Decimal

3) Binary to HEX

4) HEX to Binary

6) Decimal to Binary

7) Binary to Decimal

thankyou

2. Did you weed thru the Help File? If not, please do so by looking for e.g., DEC2BIN, etc.

3. I know this:-

DEC2HEX(number,places)

as iam doing assembly programming so i need to get the value in proper format which i am unable to get from excel...

Like if i want to convert 256 Decimal into Hex using the above formula i get the following answer which i don't understand

DEC2HEX(256,1) = #Num

how i can correct this

4. when i want to convert 65536 into hex from decimal ,

how to use the DEC2HEX formula which can bring the answer in upper byte and lower byte format as rite now i have placed the following

DEC2HEX(65536,5) iam getting = 10000 answer..
i want it to get into upper byte and lower byte.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•