Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rounding Percentage
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
Rounding a Calculated Percentage to the Nearest 5 | Excel Discussion (Misc queries) | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
Percentage rounding error in charts | Excel Discussion (Misc queries) |