Need Formula/VBA Code to convert date in String Format to Normal Date format

**Karthik Sen** · 02-18-2012, 04:10 AM

Hi All,

I have a Column of cells with date mentioned in the following format Sep 8,2010. Is it possible to convert them into following format - 2010-09-08

**Haseeb Avarakkan** · 02-18-2012, 04:15 AM

Hi Karthiik, try this

Select the data, press CTRL+H to activate the Find/replace

In 'Find what' box enter a comma, then 'replace with' box a comma with space. Then click Replace All

Change the cell format to Custom as , yyyy-mm-dd

**Karthik Sen** · 02-18-2012, 04:24 AM

I have tried it, but the format is not getting changed. Does excel automatically recognize Sep as 08

**Karthik Sen** · 02-18-2012, 04:25 AM

Actually not 08. its - 09 (September)

**Haseeb Avarakkan** · 02-18-2012, 04:39 AM

You need to specify the format. Select the data & right click, click on 'Format Cells'

On the first tab 'Number' down under 'Category' select "Custom"

Right side white box under 'Type' enter yyyy-mm-dd

Click OK

**Karthik Sen** · 02-18-2012, 04:54 AM

Hi Haseeb,

I have tried it but the format is not getting changed...

Need Formula/VBA Code to convert date in String Format to Normal Date format

LinkBack

Thread Tools

Rate This Thread

Display

Need Formula/VBA Code to convert date in String Format to Normal Date format

Re: Need Formula/VBA Code to convert date in String Format to Normal Date format

Re: Need Formula/VBA Code to convert date in String Format to Normal Date format

Re: Need Formula/VBA Code to convert date in String Format to Normal Date format

Re: Need Formula/VBA Code to convert date in String Format to Normal Date format

Re: Need Formula/VBA Code to convert date in String Format to Normal Date format

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions