Hi there, I did a search and tried a few things on my own prior to posting.
I would like to convert a text field that represents a date. This comes from a system report and I need it into a date format.
Sample sheet attached
Hi there, I did a search and tried a few things on my own prior to posting.
I would like to convert a text field that represents a date. This comes from a system report and I need it into a date format.
Sample sheet attached
Last edited by yaman; 10-22-2020 at 01:14 PM.
-Select the range
-Activate "Text to Columns" in "Data" tab
-Cick "Next" button, and click "Next" button again
-Choose your date format as shown in the image below
-Click "Finish"
thank you very much, it worked and I assumed it was a very simple solution.
You're welcome...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks