Formatting as date
 

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

Formatting as date
 

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

Formatting as date
 

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

But if you *really* want 5/2005, that will be a bit more complicated. :-)
--
David Biddulph

"gwplotts via OfficeKB.com" <u20269@uwe wrote in message
news:70d71a204afba@uwe...
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

Formatting as date
 

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