Text to Columns formatting

N

Nils Titley

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
 
G

Gord Dibben

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro error when formatting columns 6
Date format Workbooks Open 1
Text To Columns On A Different Sheet 12
Date Format 4
Macro delimiting text if column has value 3
defining TextToColumns with variable 2
Excel VBA help: Text file formatting 19
Text to Columns (general) reverting at end of macro 2

Top