date format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rita - 24 Feb 2004 21:59 GMT

All of a sudden my excel spreadsheet is not regognising
dates (eg 24/2/04)as a date but will recognise 2/1/04
(2nd Jan 2004)(english) as 1 Feb 2004 (american). I want
to input date the english way. What went wrong and how do
I rectify it please. It is driving me crazy.

Thank you.

Reply to this Message

Dave Peterson - 25 Feb 2004 02:16 GMT

It may be a windows setting:
windows start button
Settings|Control panel|regional settings applet

Check the date tab.

> All of a sudden my excel spreadsheet is not regognising
> dates (eg 24/2/04)as a date but will recognise 2/1/04
[quoted text clipped - 3 lines]
>
> Thank you.

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message

rita - 25 Feb 2004 08:55 GMT

That was the first thing I checked and it is set up
correctly.

>-----Original Message-----
>It may be a windows setting:
[quoted text clipped - 10 lines]
>>
>> Thank you.

Reply to this Message

Dave Peterson - 26 Feb 2004 02:19 GMT

Sorry, I don't have a second guess.

> That was the first thing I checked and it is set up
> correctly.
[quoted text clipped - 19 lines]
> >ec35720@msn.com
> >.

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message

- 26 Feb 2004 14:11 GMT

choose format cells by right clicking a cell or menu -->
format cells; choose "number" tab choose date and check
that YOUR input format is there. If not, choose "custom"
and add your format ddmmyy or d-m-yy or ... You can see
samples of coding in the "date" section. My local
(location) is set for "Eglish (United States)" and seems
to have many of the day month year formats; perhaps this
changed somehow.

Good luck

>-----Original Message-----
>All of a sudden my excel spreadsheet is not regognising
[quoted text clipped - 5 lines]
>Thank you.
>.

Reply to this Message

Rate this thread: