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