I have a drop-down box for a cell. It will convert my selection to a date even though it is not a date. How do you stop it from converting text to date. I set the cell as a text format and it looked fine until I retrieve the data, the cell will populate with my formuala instead of the data as follows:


Here is a sample of the code that retrieves the saved data:

ActiveCell.FormulaR1C1 = _
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False