|
|
#8
08-12-2011, 08:55 AM
|
|||
|
|||
columns D and AD in sheet 1 are formatted as text. You should format these columns as date, and if necessary, reenter data, because in AD1, there is a text: "Nov-09" !! this is just a piece of text to excel, cannot recognize it as a date...There is no way excel can recognize it as 11/3/2009...( Nov can be recognized as month 11, but the day does not appear in that text
 ). in you file sheet1 reatached, i reformatted columns D and AD, and reentered 11/3/2009 in AD1. You should have no errors now..tell me if you need further assistance in automatic reformatting and reentering existing data if you have a large number of rows... 
|
| Tags |
| formatting |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Date formatting
|
kjxavier | Excel | 6 | 08-12-2011 05:46 AM |
|
Date Formatting in MS word 2007
|
Karthick | Word | 4 | 01-19-2010 05:54 AM |
|
Inserting Date, formatting to superscript and subscript
|
louq | Word | 1 | 10-22-2009 09:29 AM |
| new appointment date always reverts back to today's date | msills | Outlook | 0 | 08-24-2007 08:57 AM |
|
Imported message date change to today's date
|
promark | Outlook | 1 | 12-23-2005 07:21 AM |
Windows Vista 
Office 2007
Threaded Mode