hi jim, the quotes are still there with Paste Special | Values

On Feb 7, 11:22 pm, "Jim Cone" wrote:
Paste "Values" by going to the Edit (menu) | Paste Special | Values
--
Jim Cone
San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware

"joeycalisay"
wrote in message
is this inefficient? are there any settings that i can just use?

On Feb 7, 6:22 pm, Gary''s Student

wrote:
Enter and run this small macro:

Sub tickout()
Dim r As Range
For Each r In Selection
r.Value = r.Value
Next
End Sub
--
Gary''s Student
gsnu200704

"joeycalisay" wrote:
i have noticed that when data being pasted to an excel worksheet have
single quotes on all cells, it is being retained by excel. i just
want excel to treat all data as text. anyway to force excel to render
each cells without the single quotes?