I feel like I should be able to figure this out as it seems like it would be simple, but I'm stumped.

- I input a date (April 6, 2006) in cell A1. Cell A1 is formatted for Dates.
- I then type this into cell D1:

="Sales total for "&A1

I want my result to read "Sales total for April 6, 2006"
but instead I get "Sales total for 38813"

It's putting the date in its numeric value. I've tried formatting D1 as Date, as Text, but nothing seems to work.

Help?

Thanks