Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 05-10-2016, 01:24 PM
macropod's Avatar
macropod macropod is offline Prevent XL from reformatting when data copy/pasted Windows 7 64bit Prevent XL from reformatting when data copy/pasted Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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 you're only interested in the year part, you could use:
=IF(LEN(A3)<5,A3,YEAR(A3))

In a situation where some data have only years and other data have months & years, that would seem to be the most consistent way of analysing them; otherwise you'd need to analyse the data with months & years separately from the data with years only, to avoid skewing the analysis.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



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 XL from reformatting when data copy/pasted Prevent access to raw data in a pivot table? Chancy Excel 3 02-03-2015 11:33 AM
Prevent XL from reformatting when data copy/pasted Conditional Formatting over copied and pasted data kb3264 Excel 6 07-11-2012 07:12 AM
Prevent XL from reformatting when data copy/pasted Stop underlining pasted data LarryStroup PowerPoint 5 01-11-2012 12:47 PM
Prevent XL from reformatting when data copy/pasted Numbered list turns to bullets when copy/pasted cathleenmcguire PowerPoint 6 08-31-2011 08:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:55 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft