Problem with dates in excel

  • Thread starter Thread starter philipdonahue
  • Start date Start date
P

philipdonahue

I have been working on a spreadsheet for a couple of months now and in
the past two day I have begun having a problem when entering the date
in to a cell.

Everything was working fine

I would enter the date as (lets say) 8/22 and it would format it for
me to 8/22/07

Now however it is doing something like this (I enter) 8/22 and it
formats it as 8/1/22

I am sure that it is a preferance somewhere that I am missing and It
is driving me crazy.

I have not changed any of the cell formating and all of the old dated
that I have entered still look fine.

any help would be appreciated

Thank you,
Philip
 
Have you tried:

Right click the cell, select Format Cells. On the Number Tab (selected by
default), you will see a list of items under "Category". Under Category,
select Date. On the Type window to the side, select the format "3/14/01"
(personally, I prefer the "03/14/01 since months with 1 or 2 digits appear
uniformly). That's it!

If you want to apply the format to a whole column, just highlight the entire
column and do the same thing.
 
Have you tried:

Right click the cell, select Format Cells. On the Number Tab (selected by
default), you will see a list of items under "Category". Under Category,
select Date. On the Type window to the side, select the format "3/14/01"
(personally, I prefer the "03/14/01 since months with 1 or 2 digits appear
uniformly). That's it!

If you want to apply the format to a whole column, just highlight the entire
column and do the same thing.












- Show quoted text -
Click to expand...

Yes I have. That is not the problem. I can open the same sheet on a
different computer and will not have any problems.
 
I have been working on a spreadsheet for a couple of months now and in
the past two day I have begun having a problem when entering the date
in to a cell.

Everything was working fine

I would enter the date as (lets say) 8/22 and it would format it for
me to 8/22/07

Now however it is doing something like this (I enter) 8/22 and it
formats it as 8/1/22

I am sure that it is a preferance somewhere that I am missing and It
is driving me crazy.

I have not changed any of the cell formating and all of the old dated
that I have entered still look fine.

any help would be appreciated

Thank you,
Philip
Click to expand...

The navigation might be different depending on your version of Windows and how
you have things set up, but the problem is likely in your Windows Regional
Settings.

Start/Control Panel/Regional and Language Settings
Customize
Date
Calendar
"When a two-digit year is entered, interpret it as a year between:

Enter something later than 2022 -- I use 2042
--ron
 
The navigation might be different depending on your version of Windows and how
you have things set up, but the problem is likely in your Windows Regional
Settings.

Start/Control Panel/Regional and Language Settings
Customize
Date
Calendar
"When a two-digit year is entered, interpret it as a year between:

Enter something later than 2022 -- I use 2042
--ron- Hide quoted text -

- Show quoted text -
Click to expand...

Thanks for the effort, but that is not the problem I did change it
from 2029 to 2042 like yours, but sill not working.

It is acting as if I am entering the month and year instead of the
month and day.
 
Thanks for the effort, but that is not the problem I did change it
from 2029 to 2042 like yours, but sill not working.

It is acting as if I am entering the month and year instead of the
month and day.
Click to expand...

If you click on the cell, and examine the formula bar, what does it show? Does
it show 8/1/1922 or 8/1/2022 or something else?
--ron
 
Thanks for the effort, but that is not the problem I did change it
from 2029 to 2042 like yours, but sill not working.

It is acting as if I am entering the month and year instead of the
month and day.
Click to expand...


Also, check the "short-date" setting in the Regional Settings under the Control
Panel. It should be m-d-y (or at least in that order).
--ron
 
Also, check the "short-date" setting in the Regional Settings under the Control
Panel. It should be m-d-y (or at least in that order).
--ron
Click to expand...


I'm pretty sure this latter will be your problem.

For example, with US settings, 8/22 --> 22 Aug 2007

With UK settings 8/22 --> 1 Aug 2022
--ron
 
I'm pretty sure this latter will be your problem.

For example, with US settings, 8/22 --> 22 Aug 2007

With UK settings 8/22 --> 1 Aug 2022
--ron- Hide quoted text -

- Show quoted text -
Click to expand...

I thought the same thing, however the formating for the cells shows
English (United States). Is there another location in which I should
change this?
 
I thought the same thing, however the formating for the cells shows
English (United States). Is there another location in which I should
change this?
Click to expand...

Reread what I wrote. I did NOT write about the formatting of the cells. I
wrote about the short-date settings in the Windows control panel.
--ron
 
Back
Top