how do i create a formula that copy the cell from above inserting a minus
sign before the number? Thanks for your 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

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

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

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