I am assuiming you have an actual date and not a string to be converted.

dim strDate as string
strdate = format(range("A1").value, "yymmdd")
--
HTH...

Jim Thomlinson


"Glenn" wrote:

I have a date field with "yymmdd" format. I want to programatically convert
that to text that looks identical to the formatted date for use in
dimensioned variables/strings.
e.g. - date 6/10/2008 formatted looks like "080610". I want to use a/the
text string "080610" for various other uses. Can anyone help?