How Do You ADD DECIMALS To Existing Numbers In A COLUMN IN EXCEL?
Two ways: 1) you can add a column that divides all your numbers by 100. If your prices are in column A, then on row 2, for example, you would have =A2/100, and then copy the formula down for all your rows. OR 2) put 100 in a cell somewhere – Edit – Copy that cell – select all of your prices – Edit – Paste Special – Divide The above assume that your prices are numerical. If they are text, then instead of #1, you would use =VALUE(A2)/100 Hope that helps. If you need more info, add more details or e-mail. Good luck. .
