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

[someone]

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

 

[Aladin Akyurek]

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

 

[someone]

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

 

[someone]

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.

 

[Aladin Akyurek]

Have a look at these threads whether they are of any help to you...

http://makeashorterlink.com/?T2A923D73

http://makeashorterlink.com/?B6C922D73

http://makeashorterlink.com/?P20A42D73