use this function:
Cell A1: Date
A2=TEXT(MONTH(A1),"00")&"-"&TEXT(DAY(A1),"00")&"-"&RIGHT(YEAR(A1),2)

"lmullenjr" wrote:


I am trying to convert a date - 2/3/06 - into text format to run an
INDIRECT formula. I want the date to convert to 02-03-06 as text.
Would there be a way to do this without having to retype the date?

drummer


--
lmullenjr
------------------------------------------------------------------------
lmullenjr's Profile: http://www.excelforum.com/member.php...o&userid=33132
View this thread: http://www.excelforum.com/showthread...hreadid=573046