Date Format

[Ian McCulloch]

Hello gurus

This is strange - I am unable to format a column to a date category
(anyone). I would like ideally to see 14-Mar-01

The column has cells in this format 20030312 (used for Mar 12/03). When I
select the column and apply the date format, it all turns to pound signs.
Is there any prep work that can be done (via automation) to make the cells
ready for date format?

Really trying to save time

Any help would be appreciated

Ian

 

[Ian McCulloch]

I figured it out -

custom filter

You guys are great! Thanks

 

[J.E. McGimpsey]

one way:

Choose Data/Autofilter. Choose Custom Filter from the dropdown.

Criterion 1: is greater than or equal to 1-Nov-03
Criterion 2: is less than or equal to 30-Nov-03

 

[Peo Sjoblom]

You need to use a date format when entering a date,
20030312 is not a date in that regard. You would need to enter it
as 03/12/2003 (US format). You can however convert, select the column
with the dates, do data>text to columns, click next twice, then select date
under column data format and select YMD from the dropdown
and click finish. Then use custom format and dd-mmm-yy

 

[Ian McCulloch]

This newsgroup is excellent - I have never seen postings so quick before

Thanks all

 

[Pmxgs]

Hi,
you can also use the date wotksheet function and in the year argument
type: left(cell;4), etc