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 ]

.