Converting to/from Hex or Decimal

GoldMine CRM SQL Server QuoteWerks Microsoft Excel Microsoft Word C# Windows XP Microsoft Dynamics CRM HEAT Sage CRM

Converting to/from Hex or Decimal

To convert values in a spreadsheet from hexadecimal to decimal use the following formula.

=HEX2DEC(H4)

In the example above the cell H4 contains a hexadecimal number.

To convert values in a spreadsheet from decimal to hexadecimal use the following formula.

=DEC2HEX(I4)

In the above example the cell I4 contains a decimal number.

24 August 2009 IB Microsoft Excel

Back To List

Did this article answer your question
	Yes		No

Other items of interest in our knowledgebase

Converting fields to Propercase

Search our knowledgebase

Note:
Softstuff accepts no responsibility for the use of information contained within this item. No warranties are implied or provided and it is advised that you have a working knowledge of the technologies contained, and we will not be held liable for system downtime, or data loss caused, unless we have specifically advised in writing to you that this is the case during the course of a support issue raised and accepted by us.

Did this article answer your question

Yes

No