I have the following code in the sheet module which inserts a timestamp when certain values are changed. This gives me the date in m/dd/yyyy format. I want the format to be mm/dd/yy. I have formatted a number in VBA but can't get it right with the date. A solution would be appreciated.
Please Login or Register to view this content.
Bookmarks