View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
TheRook
 
Posts: n/a
Default can i change a number formatted as positive to negative in Excel

In an un-used cell enter -1
copy that cell
select the cells you wish to invert
pull-down:

Edit PasteSpecial... check the multiply box

"byron miranda" wrote:

I'd like to change from positive to negative numbers