Converting from Numbers to Text

[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

 

[Barb Reinhardt]

As soon as I posted this request, I figured it out. Thanks everyone.

 

[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