Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Put Sign in Excel Without Formula (5 Ways)

While working with Microsoft Excel, users may need to enter signs without using a formula at times. In some cases, putting equal signs without completing a computation or formula insertion is required. We use the ampersand and some operators as signs. With those signs, users can easily make data in a shortcut way. In this article, we will demonstrate several effective methods to put a sign in excel without a formula.


Download Practice Workbook

You can download the workbook and practice with them.


5 Effective Methods to Put Sign in Excel Without Formula

To put a sign in excel without a formula, we are going to use the following dataset. The dataset contains some employee names and the amount of their sales target. In our cases, we want to keep a track of how much of a target they are, those assigned employees fulfill in some particular time. For this, we will put some signs to audit the work of those employees.

Suppose, John’s target is 200 but he sells +240. But, many users of Excel can not put the plus (+) sign in excel without a formula. It is possible to put signs in excel without formula and it is a fundamental Excel skill.

As illustrated in the overview below, there are several ways to place signs in Excel without ever utilizing a formula. Follow any below methods to insert any sign without using an Excel formula.

5 Effective Methods to Put Sign in Excel Without Formula


1. Use Format Cells Feature to Put Sign Without Formula

Excel Format Cells feature enables us to modify the appearance of cell data in the spreadsheet. It changes the look of a number without affecting the number itself. We can put signs without formulas using the format cells feature in excel. For this, we need to follow some procedures down.

STEPS:

  • Firstly, select the cell in which you want to put a sign. So, we select cell C5.
  • Secondly, go to the Home tab from the ribbon.
  • Thirdly, under the Number category, select the tiny icon to open the Format Cells.
  • Instead of this, you can also right-click on the mouse and select Format Cells from there.
  • Alternatively, just use the keyboard shortcut Ctrl + 1 to display the Format Cells.

5 Effective Methods to Put Sign in Excel Without Formula

  • This will appear in the Format Cells dialog box.
  • Next, go to the Number menu and select Custom.
  • Further, In the Type box, type +0 as we want to put a plus sign before the number.
  • Finally, click on the OK button to complete the procedure.

  • Repeat those steps for each cell as we want to put different signs in every cell.
  • By just following the above procedures we can put any sign without utilizing the formula in excel.

5 Effective Methods to Put Sign in Excel Without Formula

Read More: How to Put 0 in Excel in Front of Numbers (5 Handy Methods)


2. Apply Apostrophe to Insert Sign in Excel

A quotation mark or apostrophe at the beginning of the cell instructs Excel that anything following it should be treated as text rather than a formula or a numeric value. We can insert an apostrophe to put a sign in excel. Let’s see the steps for this.

STEPS:

  • In the first place, select the cell where you want to put the sign without using any formula.
  • Then, insert an apostrophe before putting the sign. This apostrophe treats the number as a text.
  • But, you can view the apostrophe in that particular cell. This will display only in the formula bar.

5 Effective Methods to Put Sign in Excel Without Formula

  • Finally, to put different signs in different cells, enter an apostrophe just before the number.

Read More: How to Add Symbol Before a Number in Excel (3 Ways)


Similar Readings


3. Use Double Quotes Without Excel Formula to Put Sign

Excel employs double quotes to represent text. Double quotes mark always operate in pairs, one is at the start and the other after the quoted text. We can use the double quotes mark to sign in excel. Let’s go over the process for this.

STEPS:

  • To begin with, choose the cell where you wish to insert the sign without using a formula. So, we choose cell C5.
  • Then, enclose the sign using double-quotes. In our case, we enclose the plus sign like this; “+” then, just type the number of our data. The double quotes will show in the cell also you can view them in the formula bar.

  • Duplicate those processes for each cell, as we want distinct indications in each one.
  • We may use the previous approaches to place any sign without using the excel formula.

Read More: Excel Formula Symbols Cheat Sheet (13 Cool Tips)


4. Set Preceding Text to Insert Sign Without Formula

Users may utilize Preceding Text to put signs without ever using Excel. As demonstrated in the steps below.

STEPS:

  • Select cells and write the relevant content before inserting a sign.
  • When required Text is placed before and after the signs, and the cells’ content is shown with the signs without any problems.
  • Continue this for each cell, as we want to put different signals in each one. We can insert any sign in excel without using the formula.

5 Effective Methods to Put Sign in Excel Without Formula

Read More: How to Type Minus Sign in Excel Without Formula (6 Simple Methods)


5. Format as Text to Put Sign Without Formula in Excel

Whenever we insert numbers excel automatically formats that into numbers. So that if we want some sign in between those numbers, the user can not do this. We can change the format as text and put the sign into excel data. Let’s go through the process for this.

STEPS:

  • Firstly, select the whole cell range where you wish to insert the sign. In this case, we select cell range C5:C10.
  • Further, go to the Home tab from the ribbon.
  • Then, in the Number group, click on the drop-down list shown in the following screenshot.
  • Select Text from there.

5 Effective Methods to Put Sign in Excel Without Formula

  • Now, put the information with the sign that you want to place on your excel data without using any formula.
  • Repeat these processes for each cell, as we want distinct indications in each one.
  • We can place any indication in excel by simply following the previous processes.

5 Effective Methods to Put Sign in Excel Without Formula

Read More: How to Type Math Symbols in Excel (3 Easy Methods)


Conclusion

The above methods will assist you to Put a Sign in Excel Without Formula. Hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section. Or you can have a glance at our other articles in the ExcelDemy.com blog!


Related Articles

Sabrina Ayon

Sabrina Ayon

Hi there! This is Sabrina Ayon. I'm really excited to welcome you to my profile. Currently, I'm working in SOFTEKO as a Team Leader. I'm a graduate in BSc in Computer Science and Engineering from United International University. I love working with computers and solving problems. I’ve always been interested in research and development. Here I post articles related to Microsoft Excel. Hoped this may help you. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo