Forum Discussion

Jackie321's avatar
Jackie321
Copper Contributor
Oct 24, 2023
Solved

convert numbers in scientific (exponential) notation into date format

Hi there,   i have a data set which shows all dates and time values as numbers in scientific (exponential) notation. (1692749193000 = 169275E+12) Which steps do I need to take to convert these in...
excel
Formulas and Functions
office 365
training
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 24, 2023

    Jackie321 

    It looks like that's UNIX timestamp in milliseconds. Formula could be

    =(A1/86400/1000)+25569

    and apply date or datetime format.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 24, 2023

Jackie321 

It looks like that's UNIX timestamp in milliseconds. Formula could be

=(A1/86400/1000)+25569

and apply date or datetime format.

  • Jackie321's avatar
    Jackie321
    Copper Contributor
    Oct 25, 2023
    Thank you, Sergei. Above formula worked.

Resources