Hopefully this is a simple fix, but for some reason I can't figure it
out. I have a user from in which the user enters information through
text boxes. One text box has characters and numbers, the rest have
numbers. The one with mixed characters is a date. Specifically a
month and year. The user is instructed to use an abbreviated form,
i.e. June '06 or Sept. '06. The problem is that if the user inputs
something like June 06 instead of June '06 (missing the apostrophe) or
Sept 06 instead of Sept. 06 (no period), when I pass the value to a
cell on a worksheet, I get a number. For example, July 06 = 38904 when
passed using the code:

Range("C27").Value2 = Me.txtMonth.Value

I'd prefer to fix this without using data validation or anything like
that. Thanks in advance for any advice!

B