View Single Post
  #1   Report Post  
Nigel
 
Posts: n/a
Default 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