text: how do i create a formula in excel that multiplies a number by a percentage?   you can get by with: "=a1 * 100"  (without quotes) then set the cell format to percentage.  many times, excel will convert the number to percent if you choose that number formatting.  you can do this by clicking on format | cells and then select the number tab.  choose percentage.    it depends on how your spreadsheet is laid out, and without an example to look at, i can't give you a specific answer.  however, you can play around with: "=a1 * 100"  "=a1 * 0.01"    depending on your original number, that will probably give you the answer you need.  play around with those.