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

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?

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

Try putting an apostrophe in front

'100:1

- Search

"Catcher" wrote:

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?