Try this:

Right click inside the chart
select Chart Options
Axes
see that the "Time-scale" is not on
choose "Automatic" or "Category"

"Terry" wrote:

I set up my cell format as "text" format before I type name of sample ID
(9920-2, 9920-8, 9920-15, ...).
However, for 9920-2 and 9920-8, when I push "Enter" Xxcel changes my format
from text to date and become Feb-02 and Aug-02. 9920-15 and those after
remain the way I have set up.

Can anyone tell me how to make Excel stop changing my format and just use
text format I have set up.