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

--
briancy
-----------------------------------------------------------------------
briancyk's Profile: http://www.excelforum.com/member.php...fo&userid=1536
View this thread: http://www.excelforum.com/showthread.php?threadid=26982

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

--
Regards
Frank Kabel
Frankfurt, Germany

"briancyk" schrieb im
Newsbeitrag ...

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 a
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.
thanks


--
briancyk
---------------------------------------------------------------------
---
briancyk's Profile:
http://www.excelforum.com/member.php...o&userid=15365
View this thread:
http://www.excelforum.com/showthread...hreadid=269826

Pct = Round(Pct, 2)


On Sat, 16 Oct 2004 08:46:23 -0500, briancyk
wrote:


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 a
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.
thanks