How Do I Remove Formulas from cells?

K

kenji4861

Whenever my users type things like

"+ today's news"

or

"- I had a bad day today"

Excel thinks it's a formula and tries to do something funny. Is there
a way to make it so all the cells on my sheet avoids this?
 
G

Guest

All you have to do is type in a ' (left of the enter key
on a Windows keyboard) in front characters such as =, -,
or +. The ' tells Excel not to interpret a symbol as a
mathematical function.

:) Brent
 
P

Peter Atherton

Kenji

Excel treats + and - as numerical operators. If A1 contains
"Todays (without the Quotes) and A2 contains "-I
had a bad day today" (minus quotes)

Then =A1 & A2 = Todays I had a bad day Today

Use the Ampersand (&) with text

Regards
Peter
 
Top