Try this:

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

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

XL2002, WinXP


"gwplotts via OfficeKB.com" wrote:

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
I'm using is =A12 &"*"&P12&"*"&N12. It currently displays 04861*10A*39233. I
want it to display as 04861*10A*5/2005. any help would be appreciated.

gerald.plotts at pw.utc.com

thanks

--
Message posted via http://www.officekb.com