Thanks Edessary, is it possible to make this conditional, I assume through an
IF statement, so that if the reference cell is not Null, the Text is
converted to a value? I ask because the Imported Date/Time stamp comming
over as a Text field is of variable length, and I'd like to make the
converted column expand or collapse with the number of reference cells
imported into the column.

I'm not sure that made sense or not...

Thanks!
Kevin

" wrote:

You could convert the text to a value using the text function as
follows:

=TEXT(A2,"mm/dd/yyyy hh:mm:ss")