Maybe...

Select the range to fix -- include text and numbers
Then Edit|Goto (or hit the F5 button)
Select constants
and check numbers, but uncheck the others (text, logicals and errors)

Then do the edit|replace against that subset of the original range.

Tom wrote:

Well... That would have worked swell but there are hyphens in some of the
part descriptions and part numbers... It's the negatives inthe quantity
fields I need to change....

"Dave" wrote:

Hi Tom,
Select Replace from the Edit menu.
In the Find What field, put -
Leave the Replace With field blank.
Click Replace All (if there are no wanted negative numbers on the sheet)
Regards - Dave.

--

Dave Peterson