Re: Dates - Have Cake, Eat too

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

Maybe do this.........
Format column A as TEXT
Go ahead and enter 1/10, 1/10/05, etc etc down the column
In helper column B put this in B1 and copy down.........
=IF(LEN(A1)>=6,TEXT(A1,"mm/dd/yyyy"),TEXT(A1,"mm/dd"))

Vaya con Dios,
Chuck, CABGx3


"Manta.ray" <Manta.ray@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F5905BC6-2106-44E2-9A1F-49E3CA8722F2@xxxxxxxxxxxxxxxx
> 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: Stop autoformatted dates without using "format TEXT" or
    ... > as the delimiter> setting all columns to TEXT and eliminating the import of ... > Vaya con Dios, ... > Chuck, CABGx3 ... is there a way to stop Find and Replace from applying the format it ...
    (microsoft.public.excel.misc)
  • Re: Counting Functions
    ... Vaya con Dios, ... > change the original data to that format but it still doesnt seem to work, ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: how to convert numbers and delete leading zeros
    ... Vaya con Dios, ... Just format to Number, either before or after the Paste Special. ... only 12 significant digits. ...
    (microsoft.public.excel.misc)
  • Re: Flashing spreadsheet
    ... Are all the files which exihibit this problem of a similar nature, ... example, all the same format, just different months, or differemt accounts ... >> Vaya con Dios, ...
    (microsoft.public.excel.misc)