Solved converting excel date format

July 28, 2011 at 08:35:00
Specs: Windows 7
Hi there,

I've tried everything I can with no specialist programming knowledge to get this done but hoping someone can help out on this one.

I have a number of cells with the date format like this
Sat Oct 29 00:00:00 +0100 2011
in my spreadsheet - there are many, many lines so don't want to change them all manually. How do I get them into a normal dd/mm/yyyy format? I'm not interested in the time at all..

Excel is clearly not recognising this current format as a date - I'm on Windows 7 with MS Excel 2010.

I'm guessing I have to do a bit of VBA of some kind but would need to be walked through this quite carefully to "get" it.

Any help appreciated.


See More: converting excel date format

July 28, 2011 at 10:21:52
Very doable and vba programing not required. I will have something for you shortly is someone does not chime in before me.

Report •

July 28, 2011 at 10:27:56
✔ Best Answer
When the day in your date is less than the 10 how many digits does it show?

ie for the first does it show 01 or 1

this worked for me assuming 01 for the first (After some testing, apparently 01 and 1 did not matter) place the following in B1


Oh and then you need to format your cell for the date format you want

This assumes your data is in column A and starts in row 1.

Report •

July 29, 2011 at 01:40:44
Hi Kitty,

Thanks so much for this. Totally worked first time! :-)

Report •

Related Solutions

September 7, 2011 at 04:30:17
Thanks for the lesson Kitty... I have a freind that is having an issue with date formats as well. Would it be ok if I run her problem by you a little later this afternoon as I have not seen the problem as of yet, but it sounds similair to the previous issue.


Report •

Ask Question