![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
You could accomplish your desired ratio display without compromising the numerical value underneath with Custom Number Formatting. Consider,
... where C2 and D2 both have the formula =A2/B2 as shown in the supplied graphic's formula bar.
With that in place, select C2:C6 then right click and select Format Cells... Within the Format Cells dialog on the Number tab, select Custom from the list at the left. Within the Type text box, type in**"1:"0** (<quote><one><colon><quote><zero>). Click OK to save your custom format.
In my sample, I provided a second custom format for column D, e.g. "1:"0.0 (<quote><one><colon><quote><zero><point><zero>).
With these in place, you achieve the desired displayed ratio while the underlying number can still be used for any formula or equation.
- If this proposed solution has resolved your issue(s), please return and mark it as Answered for others to consider.