Converting date format

[Brian]

How can I convert a date (dd/mm/yy) like 14/12/05
to show up as (yymmdd) i.e. 051214 and vice versa?
Any help would be much appreciated.

Brian

 

[Peo Sjoblom]

Custom format yymmdd
if the value is 51214 with a leading zero looking like 051214
then you need a formula or data>text to columns, step 3 under column data
format, select date and YMD

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Biff]

Hi!

Just use a custom format.

Select the cell(s) in question

Goto>Format>Cells>Number tab>Custom

In the teeny tiny box below Type:, enter:

yymmdd (or whatever format you'd like)

OK out

Biff