Previous Topic Next Topic

Date formatting

Closed
Vikrant Sharma - Oct 2, 2015 at 04:44 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 2, 2015 at 05:25 PM
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.
Related:

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Oct 2, 2015 at 05:25 PM
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.
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How do i change date format in (dd.mm.yyyy)
Talha -
Catherine -

6 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Excel format
D -
sheryljohnson -

1 response
What shall i do after formatting my laptop?
upen91 -
jack4rall -

1 response