I need today's date returned as date format in formula

CMIConnie · Feb 23, 2006

I have the following formula: =CONCATENATE("W ",TODAY()). It returns W
38771, but I need it to return W 02/23/06. Is this possible?
I have Excel 2000

Gary''s Student · Feb 23, 2006

="W " & TEXT(TODAY(),"mm/dd/yy")

CLR · Feb 23, 2006

="W "&TEXT(TODAY(),"mm/dd/yyyy")

Vaya con Dios,
Chuck, CABGx3