hi,
have you tried text to columns? use fixed width.

-----Original Message-----
In a column, I have a series of numbers in this format:
00700*, 01200*,
127000*. This data comes from an outside source, and I
need the cells to
read 007, 012, 127, without the final 000*.

I can't seem to make this happen with Find/Replace,
finding 000* and
replacing with nothing (to remove the final 000*, as I
can do in Word).

Any thoughts how I might accomplish this?

Kind regards to all.
Shirley
.