How do you enter a ratio e.g. 100:1 into a cell?

[Catcher]

When I enter a ratio as above it thinks it as time. How do I do enter a
ration e.g. 100:1 in a cell?

 

[Search33]

Try putting an apostrophe in front

'100:1

- Search