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

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

I think date in A1, year in B1 so C1 put =right(B1,2)



On Apr 26, 4:18*pm, Mike H wrote:
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- Hide quoted text -

- Show quoted text -

you can format the column. Put the date in colum A, then make column B equal
to Column A (in cell b1 type =a1 and drag that down). Then select column B
and go to Format / Cells and choose Custom then type in "YY" in the Type box.

"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