A
andresg1975
how do i create a formula that copy the cell from above inserting a minus
sign before the number? Thanks for your help
sign before the number? Thanks for your help
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
kassie
If you want to "copy" A1 then use the formula =-A1
D
David Billigmeier
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
in A2:
If it is a number: =-A1
If it is a text string: ="-"&A1
D
Dave F
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
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
D
David Billigmeier
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)
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)