Excel Date Conversion

[Balamohan]

Hello , I Have an Excel file Which Has 5025 entries with a column date formatted as "dd/mm/yyyy", I have to convert these dates to these format "yyyy/mm/dd" to make this file available to my collegue. Could you give me the formula (if it exists) that could serve me and solve my problem , so that I do not have to reenter all these 5025 dates.

Thank you in advance.

[Sam.D]

Hi,
Your problem is very simple, you First have the Click a letter on the right top of your column then Select Format Cells option after the , In the Number, select Custom Then in the Type box, type:yyyy / mm / dd after that Click Ok And your job is well done

[Chandranath]

Hello , i am also for a way to convert a number to date. I can do it by hand , it is simple but when you have more than 100 entries is a long task , eg I must convert 20060803 to 03 August 2006 or 03-08-2006 or 03082006.
in excel is on course

can you please help

[Eric B]

I think what you are looking for is the Date () function, but this format is a function, meaning that you can not type directly in the cell 1997 will require you do refer to another cell type in your date (03082006) for example, make a right clik on the cell and choose "format cells" and "date".

Occasionally, dates may become formatted and stored in cells as text. For example, you may have entered a date in a cell that was formatted as text, or the data might have been imported or pasted from an external data source as text.

Dates that are formatted as text are left-aligned instead of right-aligned in a cell. With Error Checking turned on, text dates with two-digit years might also be marked with an error indicator .

Because Error Checking in Microsoft Office Excel can identify text-formatted dates with two-digit years, you can use the automatic correction options to convert them to date-formatted dates. You can use the DATEVALUE function to convert most other types of text dates to dates.

For more infomation check this
http://office.microsoft.com/en-us/ex...CH100870371033