Converting from Numbers to Text

  • Thread starter Thread starter Barb Reinhardt
  • Start date Start date
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
 
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
 
Back
Top