PC Review


Reply
Thread Tools Rate Thread

How do I change a date format 3/14/2006 to 3-14-2006 in Excel 2002

 
 
=?Utf-8?B?SmVycnkgVC4=?=
Guest
Posts: n/a
 
      15th Mar 2006

 
Reply With Quote
 
 
 
 
gjcase
Guest
Posts: n/a
 
      15th Mar 2006

Format/cells/custom

choose dd-mmm-yy

---Glen

--
gjcas
-----------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...fo&userid=2606
View this thread: http://www.excelforum.com/showthread.php?threadid=52284

 
Reply With Quote
 
gjcase
Guest
Posts: n/a
 
      15th Mar 2006

Sorry, hit send too fast. You need to adjust the dd-mmm-yy format, jus
edit it in the custom box to remove one of the "m"s.

---Glen

--
gjcas
-----------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...fo&userid=2606
View this thread: http://www.excelforum.com/showthread.php?threadid=52284

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to format a date to look like 2006-04-16T19:45:42Z pamela fluente Microsoft C# .NET 3 26th Apr 2007 09:37 AM
How to format a date to look like 2006-04-16T19:45:42Z pamela fluente Microsoft VB .NET 3 26th Apr 2007 09:37 AM
What's difference in writing date as 18/10/2006 and '18/10/2006 =?Utf-8?B?UmF2aSBHYXJn?= Microsoft Excel Misc 1 25th Oct 2006 08:44 AM
Pasted date in Excel 2003 is wrong e.g. 05-16-2006 is copied,05-15-2002 is pasted Jaap van der Veen Microsoft Excel Discussion 3 11th Aug 2006 02:08 PM
in excel tel diff. b/w 01/05/2006 and 28/02/2002 date wid formula =?Utf-8?B?a2Fud2FyIHNoYXJtYQ==?= Microsoft Excel Worksheet Functions 1 13th Nov 2005 07:00 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:25 AM.