Select the cells that the dates will be entered in and then click FORMAT on
the menu and select CELLS.

Click the NUMBER tab and in the CATEGORY column scroll down to the bottom of
the list and select CUSTOM.

To the right of the CATEGORY column is the TYPE field. Enter the following
format mask in the text box below TYPE:

mmmm d

Click OK and press <ENTER to complete the process.
--
Kevin Backmann


"Carrie" wrote:

Hi Everyone,

I am trying to write journal entries for an accounting class. I put the date
in the following format: May 15. I then hit tab to go to the next cell and
Excel changes the date format to: 15-May. How do I get it to stop that?

Carrie