Formatting as date

  • Thread starter Thread starter gwplotts via OfficeKB.com
  • Start date Start date
G

gwplotts via OfficeKB.com

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
 
Try this:

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

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

XL2002, WinXP
 
=A12 &"*"&P12&"*"&TEXT(N12,"m/yyyy")

But if you *really* want 5/2005, that will be a bit more complicated. :-)
 
Ron, that did it. Thanks so much for the quick reply

Ron said:
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
Click to expand...
[quoted text clipped - 4 lines]
thanks
Click to expand...
Click to expand...
 
Back
Top