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.