answersLogoWhite

0


Best Answer

To get the equals sign to show in a cell you put the apostrophe before it. Anything after the apostrophe is taken literally and put into a cell. So to get the equals sign to show you put:

'=

The equals sign will then be displayed in the cell, without the apostrophe showing. You can use it to put in a full formula without the formula actually calculating. This is good if you want to see the formula and the result beside each other in two cells. Into one you put your formula starting with the equals and in the other the same formula with an apostrophe before it. In one it will do the calculation and in the other it will show the formula including the equals sign.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you insert equals sign without making formula?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the advantage of making foam?

u can insert it in your mouth


What is the formula for?

making


What are the two ways of making a textual presentation of a table?

1-From Insert Menu choose "Insert Table". 2-From slide content choose insert Table.


How do you find time from the formula Velocity equals initial velocity plus gravity times time squared?

vf=vi+at² simplifying making vi=0, v=at²t²=v/at=√v/atime equals square root of velocity divided by acceleration (or gravity)


Making of ark welding rod chemical formula?

welding rod chemical formula?


When making an IF formula in Microsoft Eccel how to make your logical test equal two options ie D3 equals Asset i want if it also says credit so its like iF D3 equals credit or asset?

To test if D3 contains "Asset" or if D3 contains "Credit", then your formula should use the OR function and could be like this,: =IF(OR(D3="Asset",D3="Credit"), Do true thing, Do the false thing)


What is the chemical formula of making mummy?

This is a very complex process; a chemical formula doesn't exist.


How do you use Microsoft Excel to multiply numbers in A column and B column?

You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2


What is the formula for making cm2 to m2?

Divide by 10000.


What is formula for making of shoe polish?

colur mixing


How do you get a third of 100 without making 33.3 recurring?

Leave it in fraction form.1/3 of 100 equals exactly 100 x 1/3 = 100/3


You are making fortune cookies and typing fortunes to put on paper to insert in cookies Will that be poisonous?

no dude it wont