With the date in A1, use =TEXT(A1,"dd-mm-yy")
or =TEXT(A1,"mm-dd-yy") if you're using US-style dates.


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