Date Format

  • Thread starter Thread starter Ian McCulloch
  • Start date Start date
I

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
 
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
 
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
 
This newsgroup is excellent - I have never seen postings so quick before

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