Hi

You can use the format function
MsgBox Format(Now, "yymmdd")



--
Regards Ron de Bruin
http://www.rondebruin.nl


"jst_se" wrote in message ...
I have an auto inserted datestamp when I open a workbook. The dateformt
is yyyy-mm-dd (example: 2004-07-22), and I wonder if there are any way
to convert it to yymmdd (example: 040722)?
Here's the VBA source I use to get the datestamp:

Private Sub Workbook_Open()
If Sheets("dayreport").Range("T5") = "" Then
Sheets("dayreport").Range("T5") = Date
Else
End If
End Sub

--
//Jst
Reclaim Your Inbox!
http://www.mozilla.org/products/thunderbird/