Help with combining text and a funtion

Hello all,

I have tried everything I can think of to make this work and I am just not gettting it!

I have a cell that needs to say "Approved for Payment 3-1-05" where 3-1-05 represents the current date. This is the formula I am using now:

="Approved for payment " &TEXT(A1,"mm-dd-yyyy")

where A1 represnts the formula =TODAY()

I want to eliminate the need for the formula in A1.

Any ideas?
Thanks,
Cindy

Try...

="Approved for payment "&TEXT(TODAY(),"mm-dd-yyy")

Hope this helps!

Ah! I thought I tried that. How simple. Thank you so much for your help. Formula worked like a charm.
Cindy