Is your formula in a cell?

If so,

<formulalocation.NumberFormat = "0.00%"

replace <formulalocation with whatever syntax you want to refer to the
cell (ActiveCell, Selection, Range("A1"), Cells(1,1) etc.)