Is it possible to change numbers in spreadsheet cells from say -1.00 to 1.00
S Spreadsheet question Jun 27, 2009 #1 Is it possible to change numbers in spreadsheet cells from say -1.00 to 1.00
M Mike H Jun 27, 2009 #2 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
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
F Fred Smith Jun 27, 2009 #3 If you want to do it with a formula, it's: =-a1 Adjust the range to suit. Regards, Fred.
R Rick Rothstein Jun 28, 2009 #4 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)
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)
