WHY DATE FORMAT??
 

My cell is formatted for ...GENERAL!

I type in 9-6 to depict a football score.

The outcome is 6-Sept...instead of 9-6.

The format JUMPS to CUSTOM ...(d-mmm)!!!!!!!!!!!!!

Why does this occur?

Thanks,

FLKulchar

WHY DATE FORMAT??
 

Excel likes to help. If it sees you enter something that looks like a date, it
figures you want to use a date.

But sometimes this helping is irritating.

You can either pre-format the cell as text or start your entry with an
apostrophe like: '9-6



F. Lawrence Kulchar wrote:

My cell is formatted for ...GENERAL!

I type in 9-6 to depict a football score.

The outcome is 6-Sept...instead of 9-6.

The format JUMPS to CUSTOM ...(d-mmm)!!!!!!!!!!!!!

Why does this occur?

Thanks,

FLKulchar

--

Dave Peterson