|
|
#7
05-10-2016, 01:09 AM
|
||||
|
||||
If someone inputs merely a year number, Excel won't convert that to a date, so there's no issue there; it's only where a month is input that Excel might do a conversion - and then always to the 1st of the month if no day is input. Easy enough to handle without re-typing anything.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Style for Text Changes from Normal to Heading 1 when Copy-Pasted | Basia | Word | 8 | 08-15-2015 02:32 PM |
 Prevent access to raw data in a pivot table?
|
Chancy | Excel | 3 | 02-03-2015 11:33 AM |
|
Conditional Formatting over copied and pasted data
|
kb3264 | Excel | 6 | 07-11-2012 07:12 AM |
|
Stop underlining pasted data
|
LarryStroup | PowerPoint | 5 | 01-11-2012 12:47 PM |
|
Numbered list turns to bullets when copy/pasted
|
cathleenmcguire | PowerPoint | 6 | 08-31-2011 08:07 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode