date format problem
Hi,
i have a problem. my userform has a text box that enters the date when used.
my code is this:
UserForm1.TxtQuoteDay.Text = (Date, "Long Date")
the problem is, when the data is entered to my sheet, the date comes out
like this:
09 May 2005//
Everything is fine except for the //. Can this be removed or am i doing
something wrong? the cell format is date 09 May 2005.
Help appreciated.
Regards,
Nigel
|