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 ]

.