excel vba courses - Excel 2003. Formating Columns

Dear Maria

Thank you for attending Excel Intermediate Course.

Following function should be able to resolve the problem.

Normally when you copy and paste "numbers from the internet they are copied with extra spaces or non-breaking spaces [Char(160)] attached.

Following should help to resolve the problem:

Please insert a blank new column to the right hand side of the column you want to convert and type the following function to one cell.

=SUM(TRIM(SUBSTITUTE(cell,CHAR(160),"")))

Please note that cell in the above formula should be replaced with the appropriate cell that contains the number you want to convert.

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn