How can I easily add an apostrophe to the beginning of an entry in a cell for multiple rows?
 

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.

How can I easily add an apostrophe to the beginning of an entry in a cell for multiple rows?
 

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.

How can I easily add an apostrophe to the beginning of an entry in
 

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.

How can I easily add an apostrophe to the beginning of an entry in
 

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.

How can I easily add an apostrophe to the beginning of an entry in
 

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.