Now why didn't I think of that? <vbg

Rick


"Teethless mama" wrote in message
...
Try this:

TEXT(A1,"yymmdd")


"Julie" wrote:

I have spreadsheets with dates I need to convert in order to send info.
to
customer electronically.

Current spreadsheet shows 09/20/08 or September 20, 2008
Need it to show 080920 with no slashes

Can anybody help me?

--
Julie