Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change sign of a column of figures from + to -
That's it really
Visa account downloads with expenditure in positive figures, I want to put it into spreadsheet as negative without creating another column. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change sign of a column of figures from + to -
Put -1 in a spare cell. Copy. Select the cells you want to change from +
to -. Edit/ Paste Special/ Multiply. You can now delete the -1 from the spare cell if you wish. -- David Biddulph "Judith" wrote in message ... That's it really Visa account downloads with expenditure in positive figures, I want to put it into spreadsheet as negative without creating another column. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change sign of a column of figures from + to -
On Jan 26, 11:48*pm, Judith wrote:
That's it really Visa account downloads with expenditure in positive figures, I want to put it into spreadsheet as negative without creating another column. In a blank cell, type -1. Then with the cell selected, copy the -1. Then select the range of numbers for which you want to reverse the sign and do a paste special multiply. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change sign of a column of figures from + to -
On Saturday, January 26, 2008 10:48:00 PM UTC+3, Judith wrote:
That's it really Visa account downloads with expenditure in positive figures, I want to put it into spreadsheet as negative without creating another column. It works pretty well...awsome |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change value in column to negative figures | Excel Discussion (Misc queries) | |||
how can i change dollar sign to rupee sign in sales invoice | Excel Discussion (Misc queries) | |||
can I change the $ sign to a £ sign in an MS template? | Excel Worksheet Functions | |||
How to convert FIGURES in one column to WORDS in another column? | Excel Discussion (Misc queries) | |||
How do I change location of figures within a column | Excel Worksheet Functions |