change date format to excel format

's Computer Specifications

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?

's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

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