Is it possable to change all #N/A errors to 0 globally?

Even by the each cell would be fine.

However, once data (numeric) is inserted the data must show and not th
"0

--
Message posted from http://www.ExcelForum.com