Thread: Hex conversion trouble
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fan924 Fan924 is offline
external usenet poster
  
Posts: 238
Default Hex conversion trouble
StartIt = Val("&h" & HexStartIt)

For HexStartIt under 7FFF, I get a positive number.
With 842D, I get -31697. How can I fix this?

Excel 97



Reply With QuoteReply With Quote