About Us

Ron Rosenfeld

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merging Dates from Excel - Word Simple Problem!	CFD	Excel Discussion (Misc queries)	1	July 13th 06 01:08 AM
dates problem	mita	Excel Discussion (Misc queries)	4	June 2nd 06 12:19 PM
add/subtract dates problem in Excel.....	Gary in Pennsyl	Excel Discussion (Misc queries)	3	May 31st 06 08:58 PM
Dates Problem	nicole0904	Excel Discussion (Misc queries)	5	May 10th 06 02:47 PM
Problem Dates	Andy Cohen	Excel Discussion (Misc queries)	1	September 16th 05 01:29 AM

Menu

About Us