Results 1 to 3 of 3

Thread: How do I place a simple.

  1. #1

    How do I place a simple.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I need to place a "-" or a "+" sign in a cell, so that when I save as a CSV file it will still be the same. What happens (even if cell formatted in text) is I get a cell location as if I want to start a formula calulation . The saved CSV shows a -0 for the - sign and a 0 for the +! How can I set up the cell (column) so that I get what I put in it?
    Thanks for any help, Don

    Note: I tried to do a proper search for this problem, but was hamstrung by not knowing how to form my search.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,491
    Articles
    0
    Excel Version
    Excel 2016
    precede the - or + with an apostrophe (').

    e.g. '- or '+


  3. #3

    How do I place -

    Quote Originally Posted by NBVC View Post
    precede the - or + with an apostrophe (').

    e.g. '- or '+
    That works! Thanks, it's probably in EXCEL 101 but I missed it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •