Converting downloaded data from text to numeric

[BarryHWhite]

Here are 2 fields downloaded from a service
Field One Field2
430.86

I have copied the fields, the first containing a number but in text format, the second (which may not copy correctly) being blank but I think in text format

I have tried various combinations of if, isnumber, and value.

I would like a formula which returns the number if it is a number, or 0 if blank.
Using Value works if it is a number, but returns #value if not, and I cannot find an isnumber function combined with an if which works with the blank and allows me to return 0

[JBeaucaire]

Assuming the first "text-number" is in A2, put this in B2 and copy down:

=IFERROR(A2+0, 0)

[popipipo]

Multiply everything with 1 and a number with text format becomes a real number

[BarryHWhite]

The multiply by 1 is a good idea, and works when there is something in the cell.
When there is a blank cell in a new spreadsheet, this also works, converting the blank to number 0.

However the cell which is there as a download from an outside source seems to have
something different about it. It shows as a blank, but multiply by 1 gives #VALUE!

I found an answer
=IF(IFERROR(+VALUE(D9),0),VALUE(D9),0)

Value(D9)converts the D9 cell to a number.
if this value is an error, the result is 0.
If not an error (a number) the result is the number.

Seems complicated, but it works

Thanks for help offered.

[samba_ravi]

Use Text to Columns

Select the Column in which you have data
Then Select Text to Columns under Data
Then Select Finish button under Convert text to Column Wizard - Step 1 of 3 without selecting any thing

[BarryHWhite]

Thanks Sila

That is the simplest solution.

[JBeaucaire]

Interesting solution. The formula in post #2 didn't work?

[BarryHWhite]

My apologies, your method does work.
When I tried it before I got a reference wrong so though it did not work.