Display a Ratio

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


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




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. Required fields are marked *

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