Cell Format Issue

  • Thread starter Thread starter Dennis Tucker
  • Start date Start date
D

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
 
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.
 
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
 
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.
 
Back
Top