Display Formula Result as Percentages

[deck-b]

Hi All

I cannot reduce the decimal places in the below formula

Can anyone help?

GR's	Co Product GR's	Total GR's		Result		=(C22/E22)&":"&(D22/E2)
32,325.00	28,200.00	60,525.00		0.534076827757125:0.465923172242875
				Preferred Result
				53%:47%
				or
				53:47

<colgroup><col width="119" style="width: 89pt; mso-width-source: userset; mso-width-alt: 4352;"> <col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <col width="109" style="width: 82pt; mso-width-source: userset; mso-width-alt: 3986;"> <col width="101" style="width: 76pt; mso-width-source: userset; mso-width-alt: 3693;"> <col width="110" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4022;"> <col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;"> <col width="97" style="width: 73pt; mso-width-source: userset; mso-width-alt: 3547;"> <tbody> </tbody>

 

[Joe4]

Try:

=TEXT(C22/D22,"0%") & ":" & TEXT(D22/E22,"0%")

 

[Misca]

Try something like:

=TEXT(C22/E22,"0%")&":"&TEXT(D22/E22,"0%")

 

[ClaireS]

=text(c22/e22,"0%")&":"&text(d22/e22,"0%")

 

[deck-b]

Thanks everyone, that worked!