Issues using Today()

[salmonrose]

I am trying to use Today() function as following:

="Last updated "&Today()

And want it to display like this: Last Updated Dec 1, 2011

However, it is displayed as: Last Updated 40787


How can I change it to display the way I want it to?

Thanks.

[TMS]

Something like:

="Last updated "& Text(Today(), "mmm d, yyy")

Regards