PC Review


Reply
Thread Tools Rate Thread

change date format to excel format

 
 
Motta
Guest
Posts: n/a
 
      11th Mar 2010
Hi, I have a date in 01.03.2010 format, how can I change it by using vba for
every time I import the data?
 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      11th Mar 2010
You can use Data>Text To Columns and use the last tab to set dates.

I just recorded a macro to do it, and after tidying it left

Columns("O:O").TextToColumns _
Destination:=Range("O1"), _
DataType:=xlDelimited, _
FieldInfo:=Array(1, 4)


--

HTH

Bob

"Motta" <(E-Mail Removed)> wrote in message
news:9B0F9328-704B-4F28-83A3-(E-Mail Removed)...
> Hi, I have a date in 01.03.2010 format, how can I change it by using vba
> for
> every time I import the data?



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Date Format to Specific Text Format When Copying adambush4242@hotmail.com Microsoft Excel Misc 3 23rd Dec 2008 03:43 PM
date format will not change in Excel Maxx Microsoft Excel Misc 3 3rd Oct 2008 08:19 PM
How do I change date yyyymmdd to a Excel-supported date format? dan Microsoft Excel Worksheet Functions 3 6th Jul 2008 11:05 PM
Change satellite julian date format YYYYDDDHHMMSS to excel date ti putley Microsoft Excel Misc 1 11th Jan 2008 06:12 PM
Change a date in text format xx.xx.20xx to a recognised date format concatenator Microsoft Excel Programming 1 24th Nov 2003 11:33 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:34 AM.