Show data in cell rather than completing a function

[TJMMARTELLA]

I often need to input data such as "1/50" or "6/10" in a cell. To avoid it carrying out a arithmetic function with the data, currently the only way I know to do it is to precede the data with an apostrophe. Is there a way to format the cell so the apostrophe isn't needed?

Thanks!

 

[VoG]

Try formatting the cells as Text before entering the data.

 

[Jonmo1]

In XL2003

Tools - Options - Transition
UNcheck "Transition formula entry"


Hope that helps.

 

[TJMMARTELLA]

I'm so disappointed in myself!! THANKS.