Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-16-2015, 01:14 PM
Snakehips Snakehips is offline Change the date format of stuborn imported data Windows 8 Change the date format of stuborn imported data Office 2013
Advanced Beginner
 
Join Date: Mar 2015
Posts: 36
Snakehips is on a distinguished road
Default

Charlietbh,

Your code will alter the format for a date in number form. I suspect your stubborn dates are text?

If so you can easily convert them by selecting >> Data tab >> Text to columns >> Next Next Finish

Then run your code if you need.



Hope that helps.
Reply With Quote
  #2  
Old 03-17-2015, 04:12 AM
Charlietbh Charlietbh is offline Change the date format of stuborn imported data Windows 7 64bit Change the date format of stuborn imported data Office 2013
Novice
Change the date format of stuborn imported data
 
Join Date: Mar 2015
Posts: 2
Charlietbh is on a distinguished road
Default

Utterly perfect, thank you
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
change date format in APA bibliography style Sunny24601 Word 0 12-05-2014 07:03 AM
Change the date format of stuborn imported data Change Mail Merge Date Format from US to UK Evanaught Mail Merge 1 09-29-2013 08:02 PM
Change format of date when using Now function in VB code Bondai Excel Programming 2 03-02-2012 05:09 PM
Change the date format of stuborn imported data Why do imported styles not change to default font? OldGrantonian Word 4 05-18-2011 06:35 AM
Change the date format of stuborn imported data Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:41 AM.


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