• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. C

    minus versus equals minus

    Thank you, I will be more careful when using formulae without starting with =. It is easy to circumvent, I was just interested in the possible reason. I checked, I cannot recreate the problem when trying to duplicate in column C - so it cannot be that. Excel still auto corrects in column C
  2. C

    minus versus equals minus

    I usually type it as =-R3. Sometimes (when I am in a hurry, and only want to make a quick calculation without needing to setup a sheet for future use) I type -R3. If I reference another column (eg -S3) I do not have the problem (excel changes the formula to =-S3), it is only (as far as I am...
  3. C

    minus versus equals minus

    Hi Hui Thank you for your reply. It does not really answer my query, but I was obviously not very clear. Why is there a difference between =-R3 and -R3?
  4. C

    minus versus equals minus

    Hi I did not know what to use as a title, so I used what I tried to google.... This is my first Chandoo.org post (even though I have been a frequent vistor for a couple of years), and if I am not making sense let me know! I have a sheet with some numbers in column R. If I reference these...
Back
Top