How to display + or - in Excel

Hello
two options
either you enter your values in text format, but they will no longer be usable for calculations, and thus
enter your values starting with the apostrophe followed by the sign and the value

or you format conditionally, (from Excel 2007 onwards only)
for example select the field A1:A100
Home ribbon/Conditional Formatting/New Rule/Use a formula..."
the formula is:
=A1<0
format> custom number format and in the type box, enter:
-standard
OK and new rule and the same with:
A1>0 and format
+ standard

thanks

--
To err is human, to persist is diabolical

Thank you both for replying so quickly;

walidovich_85. I am currently creating a table in Excel, but without calculations. It's a kind of summary, and in one place I need to include a description with the signs + and - (one above the other) and also the signs greater than or equal to, and less than or equal to.

Thank you Vaucluse, but indeed I should have mentioned that it was a table without calculations.

So if you could tell me how to do this, I would appreciate it.

--
Anah
"Everything that is not given is lost" (Indian proverb)

Hello,

The signs +, -, > and < can be inserted without any problem.
For the sign =, if it appears at the beginning of the cell, precede it with an apostrophe '

Does that solve your problem?

--
Being normal is boring... being a geek is interesting

No, that doesn't address my problem. I want the plus or minus sign, a single sign one below the other. All the signs separately can be inserted very easily. It's the double signs that I don't know how to insert.

--
Anah
"Everything that is not given is lost" (Indian proverb)

Hello,

like this ± ?
Arial: Alt+0177

eric

--
In addition to the thank you (yes, it can be done !!!), remember to mark it as resolved when that's the case (at the top near your title).
Thank you

Thank you Eric, it's nice of you to join us. Yes, but at my place, and it might be because I'm on Win7, it's Alt241 ± ±. Ah yes, I see that your shortcut does it too. So there are 2 shortcuts lol.

Thanks again. Good continuation.

--
Anah
“Everything that is not given is lost” (Indian proverb)

Sure, do you know where I can find the list of all these shortcuts??

Thank you in advance.

--
Anah
"Everything that is not given is lost" (Indian proverb)