Formatting a cell to text

[Lantz24]

I apologize if this is a stupid question...But the import tool I am using for one of our applications is requiring us to save using Excel 97-2003 Workbook. I have converted a couple coulumns to text, but inorder for the upload to take, I have to add an spostrophe infront of the number to make it "text" and upload cleanly. I want to do a find and replace to edit the columns with all the differing numbers. How do I do that? I tried to replace ?????? with '?????? and it doesn't work...Suggestions?​

 

[bkaehny]

You can use the formula below to convert a cell from a number to text:

=TEXT(A1,"General")

I don't know if that's the preferred methodology, but it works for me.

 

[AmandaCatRuth]

If you want to use VBA, and it's a fairly straightforward range, you can do:

Sub Macro1()
Range("A1:A10").Value = "'" & ActiveCell.Value
End Sub

That's a single ' enclosed by " - make sure to have all three in there.

Just change the range to whatever you need it to be.

 

[Lantz24]

That didn't work for me...I am sure I am doing something wrong...I will keep trying, thanks for the suggestion! I appreciate it!

 

[Lantz24]

I will try that...thank you!

 

[Robert Mika]

Another formula solution

Excel 2010
	A	B
1	1	'1
2	2	'2
3	3	'3
4	4	'4
5	5	'5
6	6	'6
Sheet1

Cell Formulas
Range	Formula
B1	="'"&A1