Hidden Apostrophe Being Inserted when Userform Value Entered in Cell

[tryingmybest418]

Hi all,

I have a userform with a text field for users to enter a date. When they click "submit" on the form, the date is entered into cell E4.
When I click on E4, it's showing that a hidden apostrophe has been added to the cell, preceding the date.

The cell is set as Short Date format, so I'm wondering why this is happening, and more importantly, how I can get it to stop.

Thanks!

 

[Rick Rothstein]

Hi all,

I have a userform with a text field for users to enter a date. When they click "submit" on the form, the date is entered into cell E4.
When I click on E4, it's showing that a hidden apostrophe has been added to the cell, preceding the date.

The cell is set as Short Date format, so I'm wondering why this is happening, and more importantly, how I can get it to stop.

Show us the code the is submitting the date to cell E4.