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