Hey Excel gurus?

[SonicIce]

I want to put a ratio into a cell like 1:1 or 5:6 but Excel keeps thinking I'm putting in a time of day and changes 1:1 to 1:01 and 5:6 to 5:06. How do I stop this?

 

[ChAoTiCpInOy]

Right click -> Format Cells. Pick General or something. One of those will allow you to do that.

 

[SonicIce]

thanks