Excel Userform converting text incorrectly into date

[Collie]

Hi all

I have created a userform that works well except for a textbox that is converting normal text into a date. A valid value for this text box is MAR51, which incorrectly gets converted to 01 Mar 1951, whereas MAR51 is the correct value. even more baffling is that this isn't happening every instance of MAR51. Also, this is the only text that gets converted, whereas there are thousands of combinations of three alphas followed by two numerics.
Any help would be appreciated


Collie

 

[diddi]

are you dumping the textbox value into a worksheet

 

[Collie]

are you dumping the textbox value into a worksheet

Hi diddi
yes it is outputting the value as a date into the workskeet

 

[diddi]

select the columns in the worksheet and set the formatting to 'text'

 

[Collie]

select the columns in the worksheet and set the formatting to 'text'

Thank you diddi, that worked. Previously the column was formatted as General

 

[diddi]

excel auto interprets text to see if it is a date. setting to 'text' disables this feature.
glad it sort your problem

 

[Collie]

excel auto interprets text to see if it is a date. setting to 'text' disables this feature.
glad it sort your problem

thank you diddi, although the solution is now obvious, and I feel like a dill, I appreciate you taking the time to respond. Thank you