Excel Formula - Percentage formula should be two decimals only.

[Dhamo]

Hi,


My requirement is to add percentages with two decimal points in other cell by formula (Not by macro) when values changes in other cells.


Eg.


Input:

Al: 5, B1: 10


Expected output: C1: 5/10 : 50.00%

Actual Output: C1: 5/10 : 50%

Formula: =A1&"/"&B1&" : "&(A1/B1)*100&"%"

But when I add this formula, I got 5/10 : 50%


Please help me in this regard.

 

[bobhc]

Good day Dhamo


Increse your decimal range using the numbers section of the ribbon (2010)not sure where it is in 2003

 

[Luke M]

Try this:

=A1&"/"&B1&" : "&TEXT(A1/B1,"0.00%")

 

[Dhamo]

Thanks Bobhc and Luke.


@Luke, Your code is worked.