Text to Columns formatting
 

This is the output from a macro that recorded from Text To Column.

Selection.TextToColumns Destination:=Range("A8"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False,
Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False,
FieldInfo _
:=Array(1, 4), TrailingMinusNumbers:=True

This macro takes a date and converts it to dd/mm/yyyy.

Where does it get the format for the dd/mm/yy? Can I use this to convert a
date before I write it to a worksheet?

Thanks

Text to Columns formatting
 

Probably gets the format from your Windows Regional setting for short date.


Gord Dibben MS Excel MVP

On Mon, 7 Apr 2008 13:52:44 -0700, Nils Titley
wrote:

This is the output from a macro that recorded from Text To Column.

Selection.TextToColumns Destination:=Range("A8"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False,
Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False,
FieldInfo _
:=Array(1, 4), TrailingMinusNumbers:=True

This macro takes a date and converts it to dd/mm/yyyy.

Where does it get the format for the dd/mm/yy? Can I use this to convert a
date before I write it to a worksheet?

Thanks

Text to Columns formatting
 

Gord,

Could you look at Data Problem.....

Thanks

"Gord Dibben" wrote:

Probably gets the format from your Windows Regional setting for short date.


Gord Dibben MS Excel MVP

On Mon, 7 Apr 2008 13:52:44 -0700, Nils Titley
wrote:

This is the output from a macro that recorded from Text To Column.

Selection.TextToColumns Destination:=Range("A8"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False,
Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False,
FieldInfo _
:=Array(1, 4), TrailingMinusNumbers:=True

This macro takes a date and converts it to dd/mm/yyyy.

Where does it get the format for the dd/mm/yy? Can I use this to convert a
date before I write it to a worksheet?

Thanks

Text to Columns formatting
 

What is that?

The subject line of another posting?


Gord

On Mon, 7 Apr 2008 14:36:02 -0700, Nils Titley
wrote:


Could you look at Data Problem.....

Thanks

Text to Columns formatting
 

Yes,

It is 7 problems before this.

Thanks

"Gord Dibben" wrote:

What is that?

The subject line of another posting?


Gord

On Mon, 7 Apr 2008 14:36:02 -0700, Nils Titley
wrote:


Could you look at Data Problem.....

Thanks