Number format problem

Originally Posted by FDibbins

Ok try this...

in H, i entered this, and copied it down...

=F3*1

Your cells are linked to, I presume, the source, and are on the if you look at the cell, it has ='MT4'|BID!EURUSD in it. That is normally a link to another worksheet, Im not sure what it means in your case. The values without a decimal are numbers, but the numbers showing a decimal are actually text that looks like a number

So, is there a way to change that text into a number? The formula links to a trading software, nothing can be changed there. It must be solved in Excel.