|
|
#6
07-11-2012, 06:12 AM
|
||||
|
||||
Those numbers are the serial values for the dates. I'd have thought you'd only see those numbers if the cells weren't already formatted for dates. Simply change the formatting to the appropriate date format and you you should see the correct results.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| conditional formatting | otuatail | Excel | 1 | 06-06-2012 05:07 AM |
 Conditional Formatting.
|
Laurie B. | Excel | 6 | 04-09-2012 05:01 PM |
|
Stop underlining pasted data
|
LarryStroup | PowerPoint | 5 | 01-11-2012 12:47 PM |
|
Conditional formatting with AND, OR
|
Lucky | Excel | 2 | 10-03-2011 11:41 PM |
|
help with conditional formatting
|
Snvlsfoal | Excel | 3 | 07-03-2011 11:55 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode