Excel question

I am marginally competent in Excel, but have encountered a problem that has me stumped.

It seems pretty basic, but I cannot get this formula to work right:

=CONCATENATE("Total due as of ",TODAY()," to Vincente")


Everything works, except that the embedded TODAY() function displays as the pointer to the date (number of days since January 1, 1900) rather than the date itself.

How can I fix this?

tanstaafl.

="Total due as of "&TEXT(TODAY(), "mmmm dd, yyyy")&" to Vincente."

Sweet! Excel TEXT function, that is a new one to me, but you can bet I will be using it in the future. Limited capabilities, but for what it does there is no substitute short of going into VBA.

Thank you!

tanstaafl.