Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
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
 



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 12:42 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