Sorry that I have misled you since wrongly use the word asterisk [ * ]
for a quotation mark [ ' ].

Regards
Ah San

"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 ]

.