Rounding Percentage

[briancyk]

I have one excel file and all the figures inside in the cells are in
such as 95.23% in cell (1,1) and 92.46% cell (1,2). How can I write
VBA so as to convert them into 95 and 92 respectively?

Besides, I also want to set a option for users to choose:
option 1: change 95.23% to 95.23 (2 decimal place)
option 2: change 95.23% to 95 (no decimal place)

Hope you all can help me as it is very urgent in my assignment.
thank

 

[Frank Kabel]

Hi
for rounding see:
http://www.xldynamic.com/source/xld.Rounding.html#vba

 

[Myrna Larson]

Pct = Round(Pct, 2)