MrExcel Publishing
Your One Stop for Excel Tips & Solutions

DTPicker values

Posted by Henry on May 17, 2001 3:16 AM

when I have DTPicker place a value in a cell it includes the time stamp. How can I eliminate the time stamp either from the value of DTPicker or filter the cell to remove the time and leave only a format of m/d/yyyy.


Posted by Dave Hawley on May 17, 2001 4:34 AM

Hi Henry

Use the Format function, eg;

Range("A1") = Format(Now, "dd/mm/yy")

Just substitute NOW for the DTpicker.

OzGrid Business Applications