I've got a very large workbook i'm working with and a column with all numbers in them. I need to add a ' before the number to make it a string in order to input this information into a database.
Now when I put a number like 1234 in a cell and then change it so its '1234 and hit enter, after you hit entere you won't see the ' unless you click on the cell and see it in the content field near the top. This is what I need but I cannot find a formula to do this.
I did find a formula to put a ' at the begining of the number however you could still see it in the actual cell after you entered the forumla in.
I need it so the number shows but when you actually click on the number then you will see the '1234 in the top field.
Any suggestions or help would be GREATLY APPRICATED.
Thanks:D