Did you weed thru the Help File? If not, please do so by looking for e.g., DEC2BIN, etc.
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 ...
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
Did you weed thru the Help File? If not, please do so by looking for e.g., DEC2BIN, etc.
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
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.
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
Like this thread? Share it with others