Problem with dates in excel
 

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

Problem with dates in excel
 

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.

" wrote:

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

Problem with dates in excel
 

On Aug 29, 11:08 am, Storm wrote:
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.



" wrote:
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- Hide quoted text -

- Show quoted text -

Yes I have. That is not the problem. I can open the same sheet on a
different computer and will not have any problems.

Problem with dates in excel
 

On Wed, 29 Aug 2007 15:45:59 -0000, wrote:

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

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

Problem with dates in excel
 

On Aug 29, 11:41 am, Ron Rosenfeld wrote:
On Wed, 29 Aug 2007 15:45:59 -0000, wrote:
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

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 -

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.

Problem with dates in excel
 

On Wed, 29 Aug 2007 17:05:58 -0000, wrote:

On Aug 29, 11:41 am, Ron Rosenfeld wrote:
On Wed, 29 Aug 2007 15:45:59 -0000, wrote:
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

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 -

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.

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

Problem with dates in excel
 

On Wed, 29 Aug 2007 17:05:58 -0000, wrote:

On Aug 29, 11:41 am, Ron Rosenfeld wrote:
On Wed, 29 Aug 2007 15:45:59 -0000, wrote:
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

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 -

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.


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

Problem with dates in excel
 

On Wed, 29 Aug 2007 13:21:14 -0400, Ron Rosenfeld
wrote:

On Wed, 29 Aug 2007 17:05:58 -0000, wrote:

On Aug 29, 11:41 am, Ron Rosenfeld wrote:
On Wed, 29 Aug 2007 15:45:59 -0000, wrote:
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

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 -

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.


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


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

Problem with dates in excel
 

On Aug 29, 12:33 pm, Ron Rosenfeld wrote:
On Wed, 29 Aug 2007 13:21:14 -0400, Ron Rosenfeld
wrote:





On Wed, 29 Aug 2007 17:05:58 -0000, wrote:

On Aug 29, 11:41 am, Ron Rosenfeld wrote:
On Wed, 29 Aug 2007 15:45:59 -0000, wrote:
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

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 -

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.

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

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 -

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?

Problem with dates in excel
 

On Wed, 29 Aug 2007 18:51:09 -0000, wrote:

On Aug 29, 12:33 pm, Ron Rosenfeld wrote:
On Wed, 29 Aug 2007 13:21:14 -0400, Ron Rosenfeld
wrote:





On Wed, 29 Aug 2007 17:05:58 -0000, wrote:

On Aug 29, 11:41 am, Ron Rosenfeld wrote:
On Wed, 29 Aug 2007 15:45:59 -0000, wrote:
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

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 -

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.

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

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 -

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?

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