Convert Date to Text

[bvwalker1]

Hello -

I want to convert an entire column from a csv file with the following type of date formatting 12/18/2018 0:00 to entire column with text formatting in an xlsx file as 12/18/2018 12:00 AM. How can I do this?

[queuesef]

Once you have the info in Excel file, use existing format (Home/ Format/ Format Cells/ Number tab) under date - select '3/14/12 1:30 PM' OR create a custom format - where it shows 'Type:' you would enter 'mm/dd/yyyy hh:mm AM/PM' (exclude the single quote marks)

[bvwalker1]

I'm trying to automate the process though so I need to know how to do it with a macro. I am able to change the other fields just fine. I am only have trouble with this date field.

[WasWodge]

If you in a spare cell put the formula =ISNUMBER(A2) changing the A2 to a cell reference with one of the dates in it, does it give FALSE?
If it does what happens if you select the column then on the ribbon click Data - Text to Columns, click Next twice and click Finish?

[mjr veverka]

1. I'm trying to automate the process ...
2. ... so I need to know how to do it with a macro.
3. ... I am only have trouble with this date field.

Ad 1. and 3. All you need is a simple function "Text", e.g.:

Please Login or Register  to view this content.

, if the dates to be converted are in the cells of the "A" column.

Ad 2. Here the macro is not needed, although of course it can be "made" (but we must pay attention to the system date separator).

[bvwalker1]

Ad 1. and 3. All you need is a simple function "Text", e.g.:

Please Login or Register  to view this content.

, if the dates to be converted are in the cells of the "A" column.

Ad 2. Here the macro is not needed, although of course it can be "made" (but we must pay attention to the system date separator).

Thank you!