Change date format

coogan41

New Member

Join Date: Nov 2010

Location: Australia

Posts: 1

5th Nov 2010

My first post so I hope I leave happy!
[img]../images/icons/icon7.gif[/img]
I have combined a couple of Excel spreadsheets and now have around 350 rows of data. The problem I have is that the dates are in 2 different formats, as in 5/11/2010 and 5 Nov 2010. The dates aren't all the same, they vary from 1840 to 2009.

Is there some way to convert them all to one or the other format without having to manually key each one? I have tried selecting the column and using the "format cells" function, without success. Are there any shortcuts?

Thanks.

Last edited by coogan41; 5th Nov 2010 at 12:44 PM..

« What are the benefits of using 32 bit Excel 2010 on 64 bit Windows 7 | Copy formula from one workbook to another without reference to 1st »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
change date format dd/mm/yyyy to Julian date format?	itzy bitzy	Microsoft Excel Worksheet Functions	1	8th Dec 2009 07:42 PM
Change Date Format to Specific Text Format When Copying	adambush4242@hotmail.com	Microsoft Excel Misc	3	23rd Dec 2008 03:43 PM
Can I change a date with no format (20051111) to date format?	=?Utf-8?B?Um9zZQ==?=	Microsoft Excel New Users	2	11th Nov 2005 09:03 PM
Change german date-format in englisch date-format?	pedros25	Microsoft Excel Programming	2	16th Mar 2004 10:28 AM
Change a date in text format xx.xx.20xx to a recognised date format	concatenator	Microsoft Excel Programming	1	24th Nov 2003 11:33 PM