Converting date format

B

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
 
P

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
 
B

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
 
Top