How can I convert a matrix to all numeric values which contains numeric and characters both?

I have matrix containing both numerics and characters(actually NaNs) values both. How to convert this matrix so that it contains all the numeric values?Because I want to write this matrix to an excel sheet.

[Stephen23]

"I have matrix containing both numerics and characters(actually NaNs) values both"

What does this mean exactly: do you have a numeric matrix? NaN's in a numeric matrix are numeric, so your description is not clear.

[Zara Khan]

I only want replace NaNs by zero thats it.

Answer 1

[Rik]

If you want to replace the NaNs by 0, you can simply use this:

data(isnan(data))=0;

[Zara Khan]

Is this possible to pass the entire matrix and keep the numeric values as it is and change only NaNs to zero?

[Rik]

That is exactly what this does.

[Zara Khan]

I am passing the entire matrix and getting a logical matrix always. That I dont want.

[Rik]

If your variable data is a matrix that is not a logical, this code will not return a logical. What exact code are you using? Try to reduce it to a small piece of code I can run to replicate your issue.