Cell Format Issue

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
 
J

Jim

If you format the cells as text prior to entering your data, it should look the way you want.

Jim
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
 
R

Ron@Buy

Another way to force the issue, whatever the cell format, is to preceed with
a ' e.g. '2-0
 
Top