Select the cells you want to process Ctrl+h on the keyboard
type a minus sign in Find what: field
nothing in the Replace with: field
other settings as shown:
Click Replace All.
If these values are the result of formulae in those cells we'll have to do something else.
Select the cells you want to process Ctrl+h on the keyboard
type a minus sign in Find what: field
nothing in the Replace with: field
other settings as shown: View attachment 77629
Click Replace All.
If these values are the result of formulae in those cells we'll have to do something else.