How do i stop Excel from turning a value into a formula?

A

Annetoinette

All i want to do is write "+ dog" in a cell and it keeps turning it into a
freaking formula!! MAKE IT STOP!! ARGHH!
 
F

FSt1

hi
preceed your entry with an apostrophe ie '+ Dog.
you seem to be caught in up in lotus formulas. lotus formulas (not all) were
proceeded with the plus sign and excel still has the lotus conversion built
into it so that whenever it sees anything starting with a plus sign, it wants
to convert it to a formula. by preceeding the entry with an apostophe, you
would be telling excel ....."this is text, not a formula". this built in
conversion thing goes back to when excel first came out and copied lotus in
almost everything even down to the date bug that lotus had.

oh well.....
regards
FSt1
 

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

Why does forumula show in cell instead of formula result? 2
Scrabble Value calculation for Welsh words 0
Conditionally format entire worksheet 3
Conditional Formatting Confusion 8
Date format in cell 3
Nameing a function 1
Why does Conditional Formatting highlight "n/a" as a number? 5
Long Logical function 2

Top