Pivot Average ignore text NA

[Sahil123]

Hi all

I have a set a data that has N/A in there with numbers also

I have created a pivot table at the back of this data using an average function

How can i get the pivot table to ignore these N/A values that are stored as text

I export this data out and reformat via code therefore I can change the value of N/A to a non text N/A if thats easier to do and then somehow need the pivot table to ignore the N/A in the average section

How can I achieve this

Thank you