how do i enter 16-22 november, 2009 as a date in excel 2003

[LCpl Bissler, Mark J USMC]

ive been at this all morning and my brain's fried from starin at numbers--im
sure its simple and im just being dumb but i could really use the help

 

[Gord Dibben]

You don't.


Gord Dibben MS Excel MVP

 

[joel]

You can't! You ask how do I enter "A" (one date) which contradicts th
other part of the statement 16-22 (multiple dates). Yo only can ente
the range of dates as a string in one cell. You could have two column
with one column being a start date and a 2nd column the end date

 

[Kassie]

16/11/09 in one column, 22/11/09 in the next

--
HTH

Kassie

Replace xxx with hotmail

 

[joel]

16/11/09 in one column, 22/11/09 in the next

Now finally a good question. A US member of the USMC trying to enter
date in International standard (Day/Month/Year). Now that is a problem
Excel has different versions for different countries. The US versio
won't recognize the International dates, and the Internation version o
Excel won't recogmize the US dates.

the US version will only recognize an input in US format o
month/day/year, but will automaticaly convert to International standar
is you change the format of the cell(s).


Use the worksheet menu to format the cell as follows


Format - cells - Number - Custom

Then in the box type either d/m/yy, dd/mm/yy

Excel will automaticall reverse the month and date after you enter th
date

 

[David Biddulph]

Joel,

You have done something strange with your message, in that you've included
your new material as if it were part of what you've quoted from Kassie.

The thing which determines how Excel interprets dates is not "different
versions for different countries". It's determined by the Windows Regional
Options, set through Control Panel.

 

[joel]

I don't think yhou want to have somebody from the US change ther
regional setting just to send a report to somebody who is usin
international standards. The person from the US should just reforma
the date cells in a custom format. the other sloution is just use th
international date system spelling out the month so nobody get
confused.

The International standard date format is

11 November 200

 

[David Biddulph]

Joel,

You didn't quote the relevant parts of the message to which you replied, but
in reply to your:

">> Now finally a good question. A US member of the USMC trying to
.... , I said:
"The thing which determines how Excel interprets dates is not "different
versions for different countries". It's determined by the Windows Regional
Options, set through Control Panel."

You were talking not about how the number is *displayed*, but how it is
*entered*.

The cell formatting governs the *display*, and changing the format will not
change the underlying number if a date has been wrongly interpreted at the
time of entry.
The Windows Regional Settings governs the interpretation of numbers that are
*entered".

You are quite corrrect that it is safer to use an unambiguous format.
The ISO 8601 standard format is 2009-10-18