excel converts date/time value to exponential value
You can convert your number to a date/time with the formula:
=date(left(a1,4),mid(a1,5,2),mid(a1,7,2))+time(mid (a1,9,2),mid(a1,11,2),right(a1,2))
--
Regards,
Fred
wrote in message
oups.com...
Hi,
I have a CSV file that was exported by a database. However, when I
import this csv to excel, I see that the date/time value seems to have
changed to an exponential value. For example,
20060602084140 is converted to 2.00606E+13.
1. Why is this happening?
2. Can I convert 20060602084140 to a regular date / time value?
Thanks in advance,
-V
|