How can I turn off all formulas in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Excel to make forms and I do not want any formulas. Even when I
choose text in the format of a cell, Excel still puts in the formula.
Example: When I type "+1% chance for 4 bolts to corrode" in a cell already
formated as text, excel still changes it to a formula. There has got to be a
setting I could use to turn off formulas when just using Excel as a form
builder.
 
Just format the range (or entire sheet) as Text beforehand
(eg: select range, click Format > Cells > Number tab. Select "Text" > OK)
 
What leads you to believe that everything you type into a cell is being
entered as a formula?
"+1% chance for 4 bolts to corrode"
Click to expand...

When I type that into a cell (without the quotes) Excel complains and pops a
message that the formula I've entered has errors. That's because of the use
of the + sign and I've left out the quotes. A formula is entered starting
with either an = sign or a + sign. The = sign is the default symbol used by
Excel. The + sign is the default symbol used by Lotus and Excel will accept
it just to be "nice".

In your example is the + sign actually part of the string or is it a habit
carried over from Lotus?

If it's actually part of the string (having the meaning of: greater than 1%)
then start the string with an apostrophe:

'+1% chance for 4 bolts to corrode

When you enter TEXT do not start the string with either the + sign or the =
sign. When you do that Excel thinks you're entering a formula.
 
with my xl2003

in a workbook, i select sheet1
Select all cells
Format>Cell>Number>General

from anywhere here, I can type =1+1, without any trouble..

in this case i *turn-off formula writing <in this sheet1> only*.

HTH
 
swordsman said:
Format>Cell>Number>General
Click to expand...

I don't have XL2003 but are you sure that you selected General to *turn off
formula writing*?


--
Regards,


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Thanks Sandymann

Hoping Alan can catch it!
Anyway, re-again, select all cells in the worksheet and

go to > Format>Cell>Number>Text
<not General>

Maybe Sandymann can verify this the way Alan needs it! <g>.
 
Back
Top