Excel 2000-dates

J

John Kreiser

Every time I try to put in a game score (e.g. 3-2) into a
worksheet, the entry is turned into a date (e.g. 3-2
becomes 2-Mar). I can't stop it. What am I doing wrong?
 
K

Kevin Stecyk

Hi John,

I tried the same thing and got a similar result. However, if you format the
cells as text prior to entereing 3-2, it stays as "3-2" without the quotes.

Hope that helps.

Regards,
Kevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top