software

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 datagt;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
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;Brianquot; gt; wrote in message
...
gt; How can I convert a date (dd/mm/yy) like 14/12/05
gt; to show up as (yymmdd) i.e. 051214 and vice versa?
gt; Any help would be much appreciated.
gt;
gt; Brian
gt;
Hi!

Just use a custom format.

Select the cell(s) in question

Gotogt;Formatgt;Cellsgt;Number tabgt;Custom

In the teeny tiny box below Type:, enter:

yymmdd (or whatever format you'd like)

OK out

Biff

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