Cell date format

[craftyexcel]

Is there a Visual Basic fn I can use to convert the following "20020831" to a date format such as dd/mm/yyyy. Or basically any other method I can incorporate into a macro?
thanks in advance

 

[Richie(UK)]

Hi crafty,

See if this points you in the right direction.

<pre>
Sub dateformat()
Dim strDate As String
strDate = Format$(Now, "dd/mm/yyyy")
MsgBox strDate
End Sub
</pre>