Dates - Have Cake, Eat too

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have a specific need to show 'month and year' and 'day, month and year' in
the same column. Because of multiple user input, I would like to make this
as simple as possible. If they enter 1/05, I want to see January, 2005 and
if the enter 1/10/05, I want to see January 10, 2005. From what I can see,
there is no way to format the entire column and acheive the stated goal. One
must choose one format and customize/reformat individual cells, which defeats
the purpose.

Any magic out there?
.

Relevant Pages

  • Re: get the first word of a file
    ... >> I have a data file of the format ... cat serves no purpose. ... Prev by Date: ...
    (comp.unix.shell)
  • Re: Dates - Have Cake, Eat too
    ... Vaya con Dios, ... > there is no way to format the entire column and acheive the stated goal. ... > the purpose. ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: How do I compare 2 text columns & show differences in 3rd?
    ... What is the purpose of doing that? ... way to format the text so that it can be manipulated, ... if the difference is always at the end of the data string, ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: S-expression I/O in Ada
    ... the formats like S-expressions are purposeless, in the sense that there is ... no *rational* purpose behind them. ... Why can't there be general-purpose format, ... presentation format is of course a language. ...
    (comp.lang.ada)
  • Re: BMD Certificates
    ... The existence of a print-out in any format is wholly ... and is then printed out in a faux-certificate form. ... is a "positive creation of genealogical information by doing all this ... are being produced for some non-genealogical purpose. ...
    (soc.genealogy.britain)