Thread: Prevent XL from reformatting when data copy/pasted
View Single Post
 
Old 05-10-2016, 01:09 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,363
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote