Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 05-10-2016, 04:01 AM
BRDas BRDas is offline Prevent XL from reformatting when data copy/pasted Windows 7 64bit Prevent XL from reformatting when data copy/pasted Office 2007
Novice
Prevent XL from reformatting when data copy/pasted
 
Join Date: May 2016
Posts: 4
BRDas is on a distinguished road
Default

Yes, good point, but then how to structure a single formula that will deal with both possibilities and give a meaningful result? ISTEXT will be false for both and ISNUMBER will be true for both. YEAR gives the correct result when applied to the Month and Year combination, but when applied to the single four digit year it treats it as a Julian date and gives "1905". The only thing I could come up with, since none of the dates will be from the early 20th century is the following:

=IF(YEAR(E3)>1950,TEXT(E3,"mmmm") & TEXT(E3,"yyyy"),E3)

That should do it!

Thanks for your help!
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 11:35 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