Thread: - sign help
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier David Billigmeier is offline
external usenet poster
 
Posts: 176
Default - sign 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