Date value in cell with text

[tonyrulesyall]

I would like a cell in Excel 2000 to have some text plus today's date,
like this:

"Total orders as of 3/09"

I was able to pull the current date with =NOW()
and right clicking the cell and choosing the date to look like 3/09

I was thinking that my formula should look like
="Total orders as of "&NOW()

Any thoughts?

 

[Niek Otten]

="Total orders as of "& TEXT(TODAY(),"m/dd")