how do I keep excel from calculating text so it stands as is?

[jrambo]

I am creating a worksheet that I want to list football scores, i.e.
W-L
23-6
41-23
Is there a way to keep excel from actually performing the subtraction
function so when I type them this way they stay there?

 

[Don Guillett]

format as text first or put ' in front

 

[Jacob Skaria]

Pref-format the cells to text and enter the values
OR
Prefix your cell entry with an apostrophe
'23-6

If this post helps click Yes

 

[jrambo]

Thanks so much!

Pref-format the cells to text and enter the values
OR
Prefix your cell entry with an apostrophe
'23-6

If this post helps click Yes

 

[Dave Peterson]

You may want to use two cells.

Then you'll be able to do arithmetic pretty easily.