Results 1 to 5 of 5

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. #1
    New Member
    Join Date
    Feb 2003
    Location
    Pakistan
    Posts
    3

    Default

    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. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    61,998

    Default


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


  3. #3
    New Member
    Join Date
    Feb 2003
    Location
    Pakistan
    Posts
    3

    Default

    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. #4
    New Member
    Join Date
    Feb 2003
    Location
    Pakistan
    Posts
    3

    Default

    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.

  5. #5
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    61,998

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com