How can I turn off all formulas in Excel?
 

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.

How can I turn off all formulas in Excel?
 

Just format the range (or entire sheet) as Text beforehand
(eg: select range, click Format Cells Number tab. Select "Text" OK)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Alan" wrote:
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.

How can I turn off all formulas in Excel?
 

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"

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.

--
Biff
Microsoft Excel MVP


"Alan" wrote in message
...
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.

How can I turn off all formulas in Excel?
 

with my xl2003

in a workbook, i select sheet1
Select all cells
FormatCellNumberGeneral

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

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

HTH


"Alan" wrote:

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.

How can I turn off all formulas in Excel?
 

swordsman" wrote in message
...
FormatCellNumberGeneral

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


Replace @mailinator.com with @tiscali.co.uk


"swordsman" wrote in message
...
with my xl2003

in a workbook, i select sheet1
Select all cells
FormatCellNumberGeneral

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

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

HTH


"Alan" wrote:

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.

How can I turn off all formulas in Excel?
 

Thanks Sandymann

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

go to FormatCellNumberText
<not General

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


"Sandy Mann" wrote:

swordsman" wrote in message
...
FormatCellNumberGeneral

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


Replace @mailinator.com with @tiscali.co.uk


"swordsman" wrote in message
...
with my xl2003

in a workbook, i select sheet1
Select all cells
FormatCellNumberGeneral

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

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

HTH


"Alan" wrote:

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.