Hi Kristiaaan,
This formula works for me:
=--(TEXT(A1,"0000-00-00 00\:00"))
Don't forget to format the cell as date.
Regards,
KL
"Kristiaaan" wrote in message
...
I have a database with date in the following format:
"200209021600" so 2 september 2002 16:00 hr
I cannot figure out how to convert this text to the actual date and time
Who can help me?
Thanks in advance
Kristiaan
|