Thread: Format Cells for binary or hexadecimal numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Format Cells for binary or hexadecimal numbers
Rather than format, use the DEC2HEX() function
--
Gary''s Student - gsnu200739


"Cheryl" wrote:

Is it possible to enter a number in decimal but format the cell to display
the number in either binary or hexacecimal format?

I am running Microsoft Office Excel 2003 (11.8117.8122) SP2

Thank you,

Reply With QuoteReply With Quote