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

  • Thread starter Thread starter Annetoinette
  • Start date Start date
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!
 
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
 
Back
Top