View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default converting a positive number to neg number in spreadsheets

If you want to do it with a formula, it's:
=-a1

Adjust the range to suit.

Regards,
Fred.

"Spreadsheet question" <Spreadsheet
wrote in message ...
Is it possible to change numbers in spreadsheet cells from say -1.00 to
1.00