Sorry that I just want to remove the [ ' ] in front of cells with
numbers, say to change [ '1234 ] to become [ 1234 ].

Anyway, many thanks.

"Tom Ogilvy" ¼¶¼g©ó¶l¥ó·s»D
...
Dim cell as Range
for each cell in selection
if not cell.HasFormula then
cell.formula = cell.Value
end if
Next

--
Regards,
Tom Ogilvy

"ªü¤T" wrote in message
...
all asterisk which has placed unevenly in the same column of cells
by
formulas?

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