I'm trying to create a custom cell format that looks like a ratio. I.E.
24 : 1
In the custom formatting option on the cell when I try to put the following in I get an error saying it's not a valid format
# : 1
I believe this is because of how I want to use the ":" character and it's normal use with time formatting.
Is there a way to escape special characters like ":" so they appear as just text?