Thread: - sign help
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default - 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