 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2007formatting a date to look like Wed Jan 3
How do I use the custom formatting to get this result? ...Lisa Try custom format as: ddd mmm d  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > How do I use the custom formatting to get this result? > > ...Lisa Lisa, Use a custom number format of ddd mmm d SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) > How do I use the custom formatting to get this result? > > ...Lisa > Lisa, > [quoted text clipped - 13 lines] > > > > ...Lisa Thanks Max and Chip...your suggestions gave me: Mon, January 1 I would like Mon Jan 1 ...Lisa It worked ok for me. You may want to try it again. > > Lisa, > > [quoted text clipped - 21 lines] > > ...Lisa SignatureDave Peterson I can't replicate that. I tested the format "ddd mmm d" in both Excel 97 and Excel 2007, and both displayed the string "Mon Jan 1". Are you user you have 3, not 4, 'm' characters for the month. 'mmmm' will return the full name of the month. 'mmm' returns the 3-character month abreviation. SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) >> Lisa, >> [quoted text clipped - 21 lines] > > ...Lisa > Lisa, > [quoted text clipped - 13 lines] > > > > ...Lisa You're right, ddd mmm d did it. I had ddd, mmmm d I had a comma and an extra "m". Thanks again ...Lisa Good to hear you got it up there .. SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > You're right, > [quoted text clipped - 4 lines] > > ...Lisa
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.