hey all
i have messed up column A which has only dates and i have different date formats like
03/07/2013 and 07/03/2013
i need to have a fixed date for all in B like 03 July 2013
what is the easiest way ?
thank you
hey all
i have messed up column A which has only dates and i have different date formats like
03/07/2013 and 07/03/2013
i need to have a fixed date for all in B like 03 July 2013
what is the easiest way ?
thank you
Are you sure that these are dates and not TEXT that looks like days?
If yes, then format column B like dd mmm yyyy and use in B1 and copy down this.
=A1
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
format cells asi need to have a fixed date for all in B like 03 July 2013
[$-409]mmmm d, yyyy;@
Do you need to correct some dates too?
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks