date format

  • Thread starter Thread starter Arron
  • Start date Start date
A

Arron

Hi all~

Excel keeps changing my dates on me and I can't figure out how to make it
stop! I am entering my dates one of two ways, either season and year(ie Fall
1999) or month and year(ie March 1999.) My date isn't changed when I enter it
'season and year' but it does get changed when entered 'Month and year' into
a mm/dd/yyyy format. Any ideas how I could stop it from switching it on me so
I may enter the date how I wish it to be recorded?

Much thanks,
Arron
 
Precede the entry with an apostrophe: 'March 1999. The apostrophe will not
be displayed in the cell. Or, preformat the cell as TEXT.
 
If you're entering "March 1999" and you don't want it converted to a real date
(with a month, day, and year), then you can either:

Preformat the cell as Text, then do the data entry

Or

Start your entry with an apostrophe: 'March 1999
 

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

Similar Threads

Excel date formatting 1
Convert Date to MMYY format 2
Formatting Dates from Text to Numbers 2
Date Format and Sumproduct 9
Entering dates into cells as mm/yy or yy 4
Custom Date Format 3
create a month column from date column 4
sales dates 6

Back
Top