I think your macro is trying to turn formulas to
values.

I understand. It is your ineptitute. It is exactly the opposite. It keeps
you from screwing up cells with formulas, unlike Frank's code which offers
no such protection. (no criticism of Frank intended - no one is paying for
turn key solutions).

Thanks for explaining.

Regards,
Tom Ogilvy

"ªü¤T" wrote in message
...
I have tried both but I think your macro is trying to turn formulas to
values.
My problem is just to remove the ' in front of numbers only.

Really thanks to you and I will keep this macro program for my future
problems.

Regards

"Tom Ogilvy" ¼¶¼g©ó¶l¥ó·s»D
...
The functionality of Frank's code is identical to mine - yet you
imply that
mine does not work and his does.

Did you bother to try mine? Why the negative response?

Is the difference that you don't know how to add the sub declaration
at the
start and the End Sub statement on the End.

Just interested in understanding what prevented you from using the
solution
provided - your own ineptitude or was there some technical problem?

--
Regards,
Tom Ogilvy





"ªü¤T" wrote in message
...
Great, its work! Many thanks.

"Frank Kabel" ¼¶¼g©ó¶l¥ó·s»D
...
Hi
try something like
sub foo()
with activesheet.range("A1:A100")
.numberformat="0"
.value=.value
end with
end sub
-----Original Message-----
all asterisk which has placed unevenly in the same column
of cells by
formulas?

e.g. [ '12345678 ] change to [ 12345678 ]

.