Good afternoon,

I have an array of numbers in excel. I want then to display as percentage
if I've selected "proportional" from a drop down menu. I want them to
display as a number (0.00 for example) if I select "absolute" these are the
only two options in the menu.

I'ved tried using the Format code help in Excel but I can't manuipulat it to
get it to work how I want.

Any help will be greatly apprecaited.

Thank you!

Michelle