Changing a string to a number

I have a table that contains both numerical values as well as text. I would like to replace the string 'N/A' to the number 0 in the table.

Thanks for helping out a true beginner.

Answer 1

[Azzi Abdelmalek]

A={1 2 'N/A';3 'B' 5;'N/A' 0 0}  %Example
A(strcmp(A,'N/A'))={0}

[Jason]

Thanks, this got me part of the way there, but it doesn't work for tables.

[Azzi Abdelmalek]

Please post an example