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

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?

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

format as text first or put ' in front

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jrambo" wrote in message
...
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?

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

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
---------------
Jacob Skaria


"jrambo" wrote:

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?

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

Thanks so much!

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"jrambo" wrote:

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?

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

You may want to use two cells.

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

jrambo wrote:

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?

--

Dave Peterson