Hello,

I have a spreadsheet which contains a user form, and in the form there is some code to transfer data to a worksheet. The text looks like a fraction, but is actually text (actual text, 1/1, 1/2, 1/5, 1/10). After the data transfer is complete, the entered data for 1/1 is January 1 2015, the data for 1/5 is January 5 2015. The code used to move the data is:
ws2.Cells(3, 1).Value = Format(ws.Cells(lRow, 24).Value, "@")
How can I force this to stay in the text format?