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