Ron, that did it. Thanks so much for the quick reply

Ron Coderre wrote:
Try this:

=A12&"*"&P12&"*"&TEXT(N12,"M/YYYY")

Does that help?
***********
Regards,
Ron

XL2002, WinXP

I have a concatenated string that is returning the excel date format at the
end of the string (cell N12). i.e. 5/31/2007 displays as 39233. The formula
[quoted text clipped - 4 lines]

thanks

--
Rev. Jerry Plotts

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200704/1