| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
converting a positive number to neg number in spreadsheets
Is it possible to change numbers in spreadsheet cells from say -1.00 to 1.00
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
converting a positive number to neg number in spreadsheets
Hi,
Put -1 in a cell and copy it. Select your number(s) and then Edit|Paste Special - select multiply - OK Delet the -1 Mike "Spreadsheet question" wrote: Is it possible to change numbers in spreadsheet cells from say -1.00 to 1.00 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
converting a positive number to neg number in spreadsheets
On the off-chance the cell could have *either* positive or negative values
in it, and assuming the OP would want to keep the positive values as positive while only changing the negative values, that formula would be... =ABS(A1) -- Rick (MVP - Excel) "Fred Smith" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I subtract a negative number from a positive number? | Excel Discussion (Misc queries) | |||
| Converting Negative Number to Postive number | Excel Worksheet Functions | |||
| Converting a negative number to a positive number | Excel Discussion (Misc queries) | |||
| negative number to positive number | Excel Discussion (Misc queries) | |||
| converting number string to number with decimal | Excel Worksheet Functions | |||
Linear Mode
