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:
How can I force this to stay in the text format?
ws2.Cells(3, 1).Value = Format(ws.Cells(lRow, 24).Value, "@")
Have you tried to format the cell(s) as text?
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Hello,
The cells are formatted as text.
You could force the result by adding an apostrophe between two quotes before the value you really want like this:
ws2.Cells(3, 1).Value = "'" & ws.Cells(lRow, 24).Value
Last edited by kadeo; 08-31-2015 at 02:56 PM.
Please click *Add Reputation if I've helped
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks