Lets say you have a date in A1

1/1/2008

put this in b1
=A1
format B1 as yy and it wil display as 08

Mike

"Graham" wrote:

I have dates in one column. The year of the date shows in another column.
How do I get the year to show as two digit (08 etc).

Thanks