Converting from Numbers to Text

B

Barb Reinhardt

I have a column of data that has data in both number or text formats. I'd
like to convert it all to text. How do I do that? I've tried the t()
function and the text() function in another column with no success, although
I'm not sure I'm using the right arguments.

Thanks in advance.

Barb Reinhardt
 
B

Bernie Deitrick

Barb,

Select you cells and run this:

Sub ConvertToTest()
Dim myCell
Selection.NumberFormat = "@"
For Each myCell In Selection
myCell.Value = myCell.Value
Next myCell
End Sub

HTH,
Bernie
MS Excel MVP
 
Top