RE: date format keeps changing

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I probably hit something I wasn't supposed to hit. Thanks for responding
Kevin, I appreciate your time. Carrie

"Kevin B" wrote:

I'm not sure why it did that. Did you press the space bar before entering
May 15? If you did Excel would treat your entry as a text entry and not as a
date entry.

The advantage of using preformatted cells is that any valid date entry will
be formatted the the same way, but I don't know why your first 20 dates
displayed properly and the following dates did not.


--
Kevin Backmann


"Carrie" wrote:

Thank you so much! It worked perfectly now. It was doing just fine the first
20 times and then it just started changing itself. Do you have any idea why
it would start changing itself in the middle of the page?

"Kevin B" wrote:

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
.

Relevant Pages

  • Re: How do I setup 3 digit page numbers in the TOC
    ... Thanks, Kevin ... >> I have been able to use the SEQ field to have my ... >> have this format. ...
    (microsoft.public.word.vba.general)
  • RE: Calculating time difference
    ... I'm just selecting the text off the report and copy/pasting into Excel. ... Kevin Backmann ... I did format the cells. ... into the cell and it didn't work, but if I typed it in, it converted it. ...
    (microsoft.public.excel.misc)
  • Re: External data (CSV) and table styles (excel 2007)
    ... Kevin Spear, PE ... But your links to the .CSV file linked to a worksheet and a cell address, ... I have an external data file that i link into my current blank sheet. ... You can open the csv file in Excel, save as a workbook and then format ...
    (microsoft.public.excel.misc)
  • RE: Excel Error :- "Too Many Cell Formats"...is there a way of fin
    ... Aside from some VBA code to evaluate each cell for the different types of ... Kevin Backmann ... Let's say you want to format some adjacent cells with lines on the left, ... border on the left as the right border of cell A1 produces that same effect. ...
    (microsoft.public.excel.misc)
  • Re: bash, grep, and regular expressions
    ... Kevin Mark wrote: ... >>machines, but I have yet to find one that will work on my machines. ... >>the file name column in the long format. ... I can parse the beginning of words in any ...
    (Debian-User)