software

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

=quot;W quot; amp; TEXT(TODAY(),quot;mm/dd/yyquot;)

--
Gary''s Studentquot;CMIConniequot; wrote:

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

=quot;W quot;amp;TEXT(TODAY(),quot;mm/dd/yyyyquot;)

Vaya con Dios,
Chuck, CABGx3
quot;CMIConniequot; wrote:

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