View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default How to change numbers from positive to negative.

--Enter -1 in a cell. Copy the cell
--Keeping the copy select the number range
--Right clickPasteSpecialselect 'Multiply' and click OK


--
Jacob


"tammy p" wrote:

not sure if there is an easy way to do this other than physically rekeying
the number. is there a formula or something for me to use to change a number
from being positive to negative? example: 262.00 change to -262.00 or vice
versa change from negative to positive. thanks