Re: Weird date formatting

Christine wrote:
I am brand new to Excel and am having trouble formatting a date. We have different nationalities in the office where each person enters the date differently:
* month, day, year
* year, month, day
* day month year

Everyone defaults to their own country's way of doing things and we are getting very confused! To eliminate confusion, for example, I've formatted a cell "mmm-yy". But if someone enters "11-06" (for November 2006) the value becomes "Jun-06". Entering "9-07" (September 2007), it becomes Jul-06". If I enter "2007-8" it remains unchanged. The only time it works is if you actually enter the short-form month and year (Feb-07), which is kinda missing the point of formatting the cell to begin with. What is the best way around this?
One possibility would be to provide a calendar to select from such
as the one described here:

http://www.ozgrid.com/VBA/excel-calendar-dates.htm

gls858
.

Relevant Pages

  • Re: Formatted output and new_line(a) on " " systems
    ... You are talking about list-directed formatting, ... This is the first I recall of someone refering to list directed files as "unformatted" but I can understand that confusion as well. ... Support the Original G95 Project: http://www.g95.org ... Support the GNU GFortran Project: http://gcc.gnu.org/fortran/index.html ...
    (comp.lang.fortran)
  • Re: Conditional Formatting Copy Past?
    ... After you pasted into the other worksheet and with that cell still selected, ... Christine wrote: ... >> no conditional formatting set up? ... >> Try this with some test data in a new workbook. ...
    (microsoft.public.excel)
  • Re: I/O reading formated files
    ... please note that you appear to have made a common terminology ... confusion (for example, they open a file as "unformatted" because they ... formatting - list-directed formatting and explicit formatting. ... There are many circumstances in which list-directed input does the ...
    (comp.lang.fortran)
  • Re: Formatting a print statement
    ... output is a formatted file and thus you can't do unformatted output to ... Many people incorrectly refer to list-directed formatting as ... possible that the above is a consequence of the confusion that often ...
    (comp.lang.fortran)
  • Re: Formula Help?
    ... If you only have 3 colors, take a look at Format|Conditional Formatting. ... Christine wrote: ... Dave Peterson ... Prev by Date: ...
    (microsoft.public.excel)