Text To Dates

  • Thread starter Thread starter Bruce Harris
  • Start date Start date
B

Bruce Harris

I have trouble with Excel converting text to dates.

For example:
I set the row to text and enter Jan 02, Feb 02 ... Dec 02;
I copy the entries Jan 02 through Dec 02 and paste them in
the same row (Which I previously set to text);
I replace the 02 with 03 expecting to have Jan 03, Feb
03 ... Dec 03;
However, Excel, in its infinite wisdom, converts my new
items to 3 Jan 04, 3 Feb 04 ... 3 Dec 04.

How can I get Excel to accept my change and keep the
fields as Jan 03 etc. An easy fix is to use the month
fill, but I have had similar problems in the past and
wondered if what I can do to fix the worksheet.

Any thoughts, thanks
 
Bruce -

Don't format the row as text. Enter complete dates, so Excel doesn't
have to guess what you mean. For January 2002, enter 1/1/2002 or Jan 1
2002. Use a number format that displays the month and year (one of the
regular date formats, or MMM YY).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Thanks, I will try that suggestion.
-----Original Message-----
Bruce -

Don't format the row as text. Enter complete dates, so Excel doesn't
have to guess what you mean. For January 2002, enter 1/1/2002 or Jan 1
2002. Use a number format that displays the month and year (one of the
regular date formats, or MMM YY).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______



.
Click to expand...
 
Back
Top