Formula concatenating date & text converts date to number
 

Using Excel 2003

I have entered the following formula: =today() & " Net"

I want the result to be : 4/7/09 Net , but I keep getting : 39910 Net

Any suggestions?

Thanks

Formula concatenating date & text converts date to number
 

=TEXT(TODAY(),"mm/dd/yyy") & " Net"

--
Gary''s Student - gsnu200843

Formula concatenating date & text converts date to number
 

Thank you , Thank you, Thank you !!!!!

"Gary''s Student" wrote:

=TEXT(TODAY(),"mm/dd/yyy") & " Net"

--
Gary''s Student - gsnu200843