Put 0 in an empty cell
copy that cell
select all the negative numbers
goto Edit>PasteSpecial
slect the multiply option
OK
clear the previously empty cell
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
Put 0 in an empty cell
copy that cell
select all the negative numbers
goto Edit>PasteSpecial
slect the multiply option
OK
clear the previously empty cell
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
However, you can't reverse the process by finding =0* and replacing
it with -.
ed
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.