Hi,

For that string what would you like the date to be and why, all I see are
the numbers?

200811

Mike

"Toria" wrote:

Hello,

I have a number that looks like this: 2.01E+13. This is formatted as
scientific in Format Cells. This actual number is 20081100000000. This needs
to be in a date/time format, but Format Cells just gives ##############.