concatenating date and storing as text

[Parasyke]

I have several thousand records that have a date stored in a yyyy-mm-dd format like: 1999-11-29
I need to concatenate this to it: 00:00:00.000 to form: 1999-11-29 00:00:00.000
stored in a separate column as a text value and ignoring any date formatting... Any ideas greating appreciated!

[Jonmo1]

Are the original dates actually real dates, or just Text Strings ?
Use ISNUMBER(A1) to verify
TRUE = real date, FALSE = Text String

If it's a REAL Date
=TEXT(A1,"yyyy-mm-dd")&" 00:00:00.000"

If it's a text string
=A1&" 00:00:00.000"

[Parasyke]

Thanks Jonmo1!