When reading the Market Watch, the data appears with an M, a M, or even a T for different numbers. When converting the data to input it in excel, you want consistent numbers. This means when you find a number with a M for example, you want to multiply the number by 1,000,000. This page includes the code to do this.