Cyberdude
04-13-2005, 09:38 AM
I am using VBA to create a new sheet, then populate it with data. As an afterthought, I decided to add a revision date:
Range("A1") = Format(Date,"mmm d, yy")
Well, it writes the date, but the format is 13-Apr-05.
I know I can go into Excel and format it correctly, but why doesn't the VBA Format function do it for me?? :dunno
Range("A1") = Format(Date,"mmm d, yy")
Well, it writes the date, but the format is 13-Apr-05.
I know I can go into Excel and format it correctly, but why doesn't the VBA Format function do it for me?? :dunno