I am curious. Why do you want text in the cell rather than a formatted date?
If you do this, you can not do further date arithmetic with the value unless
you use the DATEVALUE function.

On Wed, 28 Sep 2005 19:29:01 -0700, "Aussie CPA"
wrote:

I'm wanting to use the edate function.
Does anyone know how I can convert the edate answer back into dd/mm/yyyy in
the cell contents rather than with formatting.