LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
I don't know but probably Lorraine O'Del
 
Posts: n/a
Default EXCEL - Please add a date format - yyyy mmm dd (mmm being letters

The date format - yyyy mmm dd (month being letters) is the most common and
most useable format for people using the date as a sort and/or search method,
particular in genealogy. I'm tired of having to see the date in the opposite
direction I want it. I want to see the year first, then the Month in a 3
letter abbreviation,then the days. An acceptable compromise would be yyyy mm
dd - then punctuation would be necessary to make the numerals more readable.
Thank you.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions
 
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
Format Cells - Date options Ben Rum Excel Discussion (Misc queries) 1 May 25th 05 05:53 PM
Keeping date format of a field inserted from an excel database Tim Cossins Excel Worksheet Functions 1 May 21st 05 12:49 AM
date format in Excel mac@bath Excel Discussion (Misc queries) 3 May 15th 05 09:27 AM
date as "mmm dd, yyyy" in the header in excel FemOkie Excel Discussion (Misc queries) 3 March 31st 05 07:26 AM
Australian date format in Excel 2000 Brian Jones Excel Discussion (Misc queries) 2 March 30th 05 06:13 AM


All times are GMT +1. The time now is 05:09 PM.

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

About Us

"It's about Microsoft Excel"