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