Format$(Now, vbLongDate)

At least, I think it is LongDate. At any rate, Format$ is the function you want.