Thread
:
Splitting Column Data into 2 fields
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
[email protected]
Posts: n/a
Splitting Column Data into 2 fields
You could convert the text to a value using the text function as
follows:
=TEXT(A2,"mm/dd/yyyy hh:mm:ss")
Reply With Quote
Splitting Column Data into 2 fields