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

Custom format yymmdd
if the value is 51214 with a leading zero looking like 051214
then you need a formula or datatext 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


"Brian" wrote in message
...
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

Hi!

Just use a custom format.

Select the cell(s) in question

GotoFormatCellsNumber tabCustom

In the teeny tiny box below Type:, enter:

yymmdd (or whatever format you'd like)

OK out

Biff

"Brian" wrote in message
...
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