Programmed error messages

[Lee]

I'm using a worksheet that doesn't allow me to enter a formula into a cell. I
get an error message saying I need to enter a number. Is there some way to
end this restriction? The worksheet & cell aren't locked.

Thanks for your help.

 

[Simon Murphy]

Lee
Try Data>>validation>>allow any value

Cheers
Simon
Blog: www.smurfonspreadsheets.net