- sign help

[Guest]

how do i create a formula that copy the cell from above inserting a minus
sign before the number? Thanks for your help

 

[Guest]

If you want to "copy" A1 then use the formula =-A1

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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)