#N/A Errors to 0
 

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

#N/A Errors to 0
 

Hi
not sure this is what you want, but change your formulas in the
specific cells to
=IF(ISNA(your_formula),0,your_formula)

HTH
Frank

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
the "0"

#N/A Errors to 0
 

Ha ha clever man Frank.

Just the job

Thank you Sir.


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

#N/A Errors to 0
 

To change globally as you requested in first post.

Sub NATrapAdd()
Dim myStr As String
Dim Cel As Range
For Each Cel In Selection
If Cel.HasFormula = True Then
If Not Cel.Formula Like "=IF(ISNA*" Then
myStr = Right(Cel.Formula, Len(Cel.Formula) - 1)
Cel.Value = "=IF(ISNA(" & myStr & "),""""," & myStr & ")"
End If
End If
Next
End Sub

Gord Dibben Excel MVP

On Thu, 29 Jan 2004 11:22:27 -0600, mikewild2000
wrote:

Ha ha clever man Frank.

Just the job

Thank you Sir.


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