View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire Shane Devenshire is offline
external usenet poster
 
Posts: 857
Default Change 18-digit dec number to hex

Hi,

First problem is that there are no 18 digit numbers in Excel. Excel support
15 digits.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Toria" wrote:

Hello,

When I have this number, 268435457800737937, Excel gives me an error when I
do the DEC2HEX formula. In an online converter, I get 3B9ACA06B551480. Any
ideas why I can't get a response from Excel?