How can I make a cell have no formula?

K

Kenji

My users keep typing

"-note for today"

and the excel cell thinks it's an equation so slaps on a "=" at the
beginning of the input.

Is there a way to set all the sells to strings instead of formulas or
equations?

Thanks!

Kenji
 
D

Dave R.

Either format the cells (before entering anything in them) as text, or
precede the text with a single apostrophe ( ')
 
P

Peter atherton

Kenji

Please do not make multiple posts.

See my reply elsewhere

Regards
Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I install Microsoft Equation 3.0 back to Office 365? 0
How can i find the max value within a time range ased on two cells 6
Ignoring text in cell formulas 3
Autonumber field in Excel that behaves the same as Access 0
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Excel does not accept text format! 0
How to Update SUM formula after inserting rows 2
Conditional Formatting Conundrum 3

Top