Skip to Content
1
Former Member
Jul 20, 2011 at 12:20 PM

Issue with a decimals for division formula

570 Views

Dear All,

I have a formula which should divide two numbers. Requirement is two have only two decimal number notation for this formula output. I have used "/" symbol for division. In the excel report it shows two decimal output but in the cell if you see it is not two decimals. And this is getting considered for further calculations and hence we are not accutate output. Any idea how to make it two decimal for the out put of a division using "/"?

Thanks in advance!

Vijaya