Did you mean something like:

UserForm1.TxtQuoteDay.Text = Format(Date, "Long Date")

And what does "when the data is entered to my sheet" mean?

If it means you take the Text in the txtquoteday textbox and put it on a
worksheet, try checking the numberformat for that cell.

If that's not it, you may want to share the code that puts it on the sheet.

Nigel wrote:

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

--

Dave Peterson