How to format a column into numbers but ignore any strings?

[richleeb2]

I have a column with numbers but they are in a scientific format.  Also in the same column I have N/A and numbers with a decimal.  How do I format this column to have all regular numbers but ignore the N/A?

1.25468233E8

15447.0

1.17894576E8

N/A

[Qiu]

@richleeb2 
For the scientific format, we can use a Text to Columns tool.

[richleeb2]

Thanks, I tried this, but this removed all of the N/A's from the output

[Qiu]

@richleeb2 

YOu mean still want the "N/A"?

Just Union Data steam from "F" anchor of first Filter tool.

[binuacs]

@richleeb2 One way of doing this

[DataNath · Accepted solution]

@richleeb2 this can be handled with a formula tool like so. We just perform a check to see if the record = N/A. If it is, we leave it as is and if not, we convert it as you wish:

[richleeb2]

Thank you, this is the most simple and it worked!