Hi Lynn,

As far as I know, "automatic formula can't be switched off for some
columns" but you can get the same effect by formatting the column as
text, eg:
*[alt + o + e], Number - choose text or
*type a single appostrophe before the plus or minus. This forces the
cell to be formatted as text.

hth
Rob Brockett
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=553527