Web Query: Number convention

L

Li Lei

Hi,

When I get external data from Web, noticed that the number format from
Europe is different.

For Example normally a number 1,300.35 is recognized in excel as one
thousand three hundred. But European number format is 1.300,35. When I
import this data into excel, excel doesn't recognize this is a number.

How do I change this European format to a normal number format
automatically? Say change 1.300,35 to excel recognized number format
1,300.35.

Thanks for your help

-Li Lei
 
Top