Cell Format Issue

[Dennis Tucker]

In sports, there are win-loss figures. I.e. 2-0 mean 2 wins and no losses. However, to put "2-0" is a cell and have it display as "2-0" is not easy. Most of the time Excel decides that you are entering a date and formats it like one. Even if I tell excel to format it as text, Excel does not display "2-0".

What is the answer, please?


Dennis

 

[åŠç†Ÿç‰›]

input ' in front of the score.
"Dennis Tucker" <[email protected]> 写入消æ¯æ–°é—»:[email protected]...
In sports, there are win-loss figures. I.e. 2-0 mean 2 wins and no losses. However, to put "2-0" is a cell and have it display as "2-0" is not easy. Most of the time Excel decides that you are entering a date and formats it like one. Even if I tell excel to format it as text, Excel does not display "2-0".

What is the answer, please?


Dennis

 

[Dave Peterson]

You could preformat the cell as Text, then do the data entry.

Or you could precede your entry with an apostrophe: '2-0

But I think you'll be happier if you used two columns--one for Wins and one for
losses (and one for ties!).

It'll make doing any arithmetic with this data much easier.

 

[Dennis Tucker]

I don't think I can do any of these options because I do not input the data.
This data is coming from a link to a table on the internet.

Also, I do not need to do any math with this data. It just needs to be
displayed correctly.


Dennis

 

[Dave Peterson]

I usually copy the data into notepad. Save the file and then use File|open.
Then I can specify how I want each field treated--text in this case.