= " The " &TEXT(C1,"$#,###") & " widgets are for sale. However they expire on "
&TEXT($D$5,"mmmm d yyyy")


Gord Dibben MS Excel MVP


On Mon, 2 Jul 2007 14:08:03 -0700, dj479794
wrote:

Cell [A1]
= " The " &TEXT(C1,"$#,###") & " widgets are for sale. However they expire
on " &$D$5

Cell [C1} = 5,000
Cell [D5] = 05/05/07
This cell is in date format.

Cell [A1] value (results) show up in cell [A3].

I can't get [A3] to show the date in date format. It shows up as 39207. Show
below:

The 5,000 widgets are for sale. However they expire on 39207.