View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sammy sammy is offline
external usenet poster
 
Posts: 48
Default How do I prefix a worksheet of numbers with a Minus (-) Sign

I have a whole worksheet full of positive numbers and would like to reverse
them to negative numbers without having to retype them in. Would anyone know
a shortcut whereby i would be able to prefix all the numbers with minus sign?

Many thanks