Why dont you post an example of the text string containing date and time.

If this post helps click Yes
---------------
Jacob Skaria


"pete" wrote:

I am trying to separate dates and times in a spreadsheet through right and
left formulas. After using these two formulas, Im getting my date answer in
the format of 40,104, etc., and the time format in a similar format. I have
tried changing the format on this and all other methods I can come up with,
but nothing seems to work for me. Anybody have a suggestion on how to make
the dates and times show up in their original format/

--
pete