Thread: Formatting formula output
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fan924 Fan924 is offline
external usenet poster
  
Posts: 238
Default Formatting formula output
Cell has the following formula
=DEC2HEX((I28-H28)/40)

The output is a hecidecimal A. I would like it to be 0A. Hex numbers
vary from 00 to FFand I neee help wiith the formatting.
Reply With QuoteReply With Quote