+ Reply to Thread
Results 1 to 4 of 4

How to get excel to ignore math symbols

Hybrid View

  1. #1
    Registered User
    Join Date
    11-16-2014
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    2

    How to get excel to ignore math symbols

    I am trying to make a chart that has symbols and their meanings, and one of the symbols is a minus sign and a plus sign.

    What I am doing is making the sign, and doing lines beside them where I can write the meaning out, like this:

    - ________________
    + ________________

    Whenever I do this, the text in the cell always changes to: #NAME?

    Is there any way I can get the text to just stay how I want it?
    Thanks for the help

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: How to get excel to ignore math symbols

    Format the cells as Text beforehand.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    11-16-2014
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    2

    Re: How to get excel to ignore math symbols

    Awesome, thanks a lot!

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: How to get excel to ignore math symbols

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Ignore maths symbols
    By marcushere in forum Excel General
    Replies: 7
    Last Post: 04-13-2012, 03:20 PM
  2. Replies: 3
    Last Post: 02-16-2006, 07:00 AM
  3. [SOLVED] two letters upon another for math symbols
    By xlstatik in forum Excel General
    Replies: 2
    Last Post: 11-29-2005, 08:10 AM
  4. [SOLVED] Ignore Symbols in a cell
    By Geo in forum Excel General
    Replies: 2
    Last Post: 03-10-2005, 12:06 PM
  5. math symbols functions
    By Fontless in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-06-2005, 05:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1