I have the spread sheet containing columns budget, expense, variance and %
Variance in cols A, B, C and D. Col D contains formulas of the form =C10/A10.
One way is Format Cells Number Custom. I think this will help you.