Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
Find formatting in text in cell, insert tags around formatting. | Excel Programming | |||
merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
Linking text columns with text and data columns | Excel Worksheet Functions | |||
extracting text from within a cell - 'text to rows@ equivalent of 'text to columns' | Excel Programming |