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

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

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

--
Gary''s Student


"CMIConnie" wrote:

> 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

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

Vaya con Dios,
Chuck, CABGx3



"CMIConnie" wrote:

> 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