I'm trying to convert a list of "number format" values to "text format"
values & I know I should add an apostrophe to the beginning of the
entry in the cell to convert it. BUT I have many rows that need to be
converted. Is there an easier way to do this? Any help's appreciated!
Thanks.

don't know your exact range, but you can give this a try, or give a more
exact range spec

Option Explicit
Dim cell As Range
Sub test()
For Each cell In Worksheets("sheet1").UsedRange
cell.Value = "'" & cell.Value
Next

End Sub


--


Gary


wrote in message
ps.com...
I'm trying to convert a list of "number format" values to "text format"
values & I know I should add an apostrophe to the beginning of the
entry in the cell to convert it. BUT I have many rows that need to be
converted. Is there an easier way to do this? Any help's appreciated!
Thanks.

What about highlighting the entire column and formatting the cells as text?

" wrote:

I'm trying to convert a list of "number format" values to "text format"
values & I know I should add an apostrophe to the beginning of the
entry in the cell to convert it. BUT I have many rows that need to be
converted. Is there an easier way to do this? Any help's appreciated!
Thanks.

Here is a tiny macro:

Sub Macro1()
Dim r As Range
For Each r In Selection
r.Value = "'" & r.Value
Next
End Sub

Just select any set of cells (row, columns, or groups) and run it


--
Gary's Student


" wrote:

I'm trying to convert a list of "number format" values to "text format"
values & I know I should add an apostrophe to the beginning of the
entry in the cell to convert it. BUT I have many rows that need to be
converted. Is there an easier way to do this? Any help's appreciated!
Thanks.

Sometimes formatting it to text doesn't work, though it is the easiest
solution. When that happens, I insert a column next to it, copy the column I
want converted and "paste special" as values.

Hope that works for you.
klm

" wrote:

I'm trying to convert a list of "number format" values to "text format"
values & I know I should add an apostrophe to the beginning of the
entry in the cell to convert it. BUT I have many rows that need to be
converted. Is there an easier way to do this? Any help's appreciated!
Thanks.