- 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
|