[SOLVED] Converting dates

[Ana]

Hi,

I need to convert the date format dd/mm/yyyy to yyyymmdd.

How would I go by?

TIA

Ana

[HiArt]

Hi Ana,

no problem, just right click in the cell, and select "Format Cells" about half-way down the list.

Select the "Number" tab.

Select "Custom" from the category list.

left click the "Type" box and use delete key to clear anything in this box (if it isn't empty already) and type in the date format of your choice, i.e. "yyyymmdd".

You should see the date in the way you want in the "Example" box.

This works because Excel holds dates as the number of days since 1 January 1900. So 9 September 2005 is held as 38604, tomorrow will be held as 38605, etc. Therefore Excel can convert this into a date in any format, so long as you tell it what you want.

For fun, try using yyyyMMMDDD (not case sensative).

HTH

Art