Date formatting

Closed
Report
-
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
-
Hi,

When I fetch raw data from a portal, the date comes in this text format Oct-02-2015. I make it in proper format 02-Oct-2015 through delimited and concatenate function. But it still remains in text until I use "f2 & Enter". I need some solution so that all active cell in this column can be converted in one go. Please help.

Thanks a lot.

1 reply

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
Vikrant Sharma, Good evening.

Try to do:

Select column with DATES
Format as DATE
Choose one cell, eg. D1 and Type 1 at this cell.
Select D1 and COPY
Select column with DATES
Special Paste --> mark option: Multiply
OK

Is this what you're looking for?
I hope it helps.