Message The Number in this cell is formatted as text or preceded by apostrephe
Then I have option of ignoring error.

I would like to do a global ingnore error instead of going to each
individual cell.

How do I accomplish this ?????

Hi
tools - Options - error'

--
Regards
Frank Kabel
Frankfurt, Germany

nach wrote:
Message The Number in this cell is formatted as text or preceded by
apostrephe Then I have option of ignoring error.

I would like to do a global ingnore error instead of going to each
individual cell.

How do I accomplish this ?????

Select the range of affected cells in your column, but you MUST start with a
cell that contains the flag. Now click the dropdown and choose Ignore Error and
they should all disappear from your selected range.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"nach" wrote in message
...
Message The Number in this cell is formatted as text or preceded by apostrephe
Then I have option of ignoring error.

I would like to do a global ingnore error instead of going to each
individual cell.

How do I accomplish this ?????


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.809 / Virus Database: 551 - Release Date: 09/12/2004