View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default How do i stop Excel from turning a value into a formula?

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

"Annetoinette" wrote:

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