by Gerry Laughlin » Mon Dec 21, 2009 7:57 pm
I would make sure that the numbers are being brought into excel as numbers instead of text. I have had to do this with any of the reports coming from GM.
The following is how I do it:
Method 3: Use Paste Special with Multiply
To use this method, follow these steps:
In any blank cell, enter the value 1.
Select the cell in which you typed 1 and click Copy on the Edit menu.
Select the cells with the values that you want to convert to numbers.
On the Edit menu, click Paste Special.
Under Operation, click Multiply. Under Paste, click Values, and then click OK.