software

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:

=quot;Sales total for quot;amp;A1

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

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--
LACA
------------------------------------------------------------------------
LACA's Profile: www.excelforum.com/member.php...oamp;userid=30381
View this thread: www.excelforum.com/showthread...hreadid=530771Try

=quot;Sales total for quot;amp;TEXT(A1,quot;mmmm d, yyyyquot;)

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;LACAquot; gt; wrote in message
...
gt;
gt; I feel like I should be able to figure this out as it seems like it
gt; would be simple, but I'm stumped.
gt;
gt; - I input a date (April 6, 2006) in cell A1. Cell A1 is formatted for
gt; Dates.
gt; - I then type this into cell D1:
gt;
gt; =quot;Sales total for quot;amp;A1
gt;
gt; I want my result to read quot;Sales total for April 6, 2006quot;
gt; but instead I get quot;Sales total for 38813quot;
gt;
gt; It's putting the date in its numeric value. I've tried formatting D1 as
gt; Date, as Text, but nothing seems to work.
gt;
gt; Help?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; LACA
gt; ------------------------------------------------------------------------
gt; LACA's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30381
gt; View this thread: www.excelforum.com/showthread...hreadid=530771
gt;
=quot;Sales total for quot; amp; text(a1,quot;dd/mm/yyyyquot;)

--

LACA Wrote:
gt; I feel like I should be able to figure this out as it seems like it
gt; would be simple, but I'm stumped.
gt;
gt; - I input a date (April 6, 2006) in cell A1. Cell A1 is formatted for
gt; Dates.
gt; - I then type this into cell D1:
gt;
gt; =quot;Sales total for quot;amp;A1
gt;
gt; I want my result to read quot;Sales total for April 6, 2006quot;
gt; but instead I get quot;Sales total for 38813quot;
gt;
gt; It's putting the date in its numeric value. I've tried formatting D1 as
gt; Date, as Text, but nothing seems to work.
gt;
gt; Help?
gt;
gt; Thanks--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=530771
Thank you both!--
LACA
------------------------------------------------------------------------
LACA's Profile: www.excelforum.com/member.php...oamp;userid=30381
View this thread: www.excelforum.com/showthread...hreadid=530771