- sign help
how do i create a formula that copy the cell from above inserting a minus
sign before the number? Thanks for your help |
- sign help
If you want to "copy" A1 then use the formula =-A1
"andresg1975" wrote: how do i create a formula that copy the cell from above inserting a minus sign before the number? Thanks for your help |
- sign help
Is the "cell above" a number or a text string? Assume you are entering these
in A2: If it is a number: =-A1 If it is a text string: ="-"&A1 -- Regards, Dave "andresg1975" wrote: how do i create a formula that copy the cell from above inserting a minus sign before the number? Thanks for your help |
- sign help
If the cell above is A1, then =CONCATENATE("'-",A1)
Note the text within the parentheses starts with a double quote mark, then an apostrophe, then a hyphen, then a double quote mark. No spaces. Dave -- Brevity is the soul of wit. "andresg1975" wrote: how do i create a formula that copy the cell from above inserting a minus sign before the number? Thanks for your help |
- sign help
Dave - Why would you put an apostrophe within the quotations? This does not
work the same as entering a numerical value with a preceding apostrophe to force it to a string. Doing it your way you will actually see the apostrophe in the cell, not what the subject wanted. Your formula should just be: =CONCATENATE("-",A1) (i.e. no apostrophe) -- Regards, Dave "Dave F" wrote: If the cell above is A1, then =CONCATENATE("'-",A1) Note the text within the parentheses starts with a double quote mark, then an apostrophe, then a hyphen, then a double quote mark. No spaces. Dave -- Brevity is the soul of wit. "andresg1975" wrote: how do i create a formula that copy the cell from above inserting a minus sign before the number? Thanks for your help |
All times are GMT +1. The time now is 04:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com