Display a Ratio

To have a value show as a ratio 5.0:1 you can use a custom number function.

ratio_1

The value in the cell is 5, but it displays as 5.0:1. This means you can still do calculations and comparisons with the value.

The format is

0.0":1"_)

 

ratio_2

Related Posts

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.