LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kelco
 
Posts: n/a
Default LIST DATES IN MONTH ORDER

I have a list of dates etc and want to sort the list to show Month/Day - the
year is irrelevant for sorting purposes but still has to be shown in the
final document. When I look into cells some have the date as 07/09/1999 and
others as July 9, 1999 ( they have been prepared on both Excel Millenium and
also Excell 2003)

How can I achieve a printed list showing month/day/year please?

(And then how do I prepare a list for printing labels?)
--
keltis
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting dates, within a list of dates jrheinschm Excel Worksheet Functions 7 April 19th 06 06:13 PM
update cells to today date in a list of dates Bill Excel Worksheet Functions 1 March 19th 06 12:30 AM
update cells to today date in a list of dates Bill Excel Worksheet Functions 1 March 17th 06 12:26 AM
list formula for dates Jim Excel Worksheet Functions 3 January 19th 06 07:12 PM
Total number of each month in a column of dates GeorgeF. Excel Worksheet Functions 1 November 19th 04 06:10 PM


All times are GMT +1. The time now is 04:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"