Format issue Figures donot match even pasted as value Excel 2007

Hi

i have put a small extract from list of 50000 values. I have Figures which are pasted as values on top and on A column but they do not agree unless i F2+enter on each figure on Column A that would mean 50000+ enteries.. i have tried copying column A and row 1 and pasting it as value but still no change. Row 1 header figures are typed manually.

Please can anyone help.

Thanks

regards

Tek9step

Highlight Column A -> Data Tab -> click Text to Columns -> on resulting dialog click Finish