Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Col alignment problem
Suppose I have a text file like this
Name Wage Robert 123 John 111,34 Mike 222,55 When I open the text file I get on Excel: Name Wage Robert 123 John 111,34 Mike 222,55 Notice that we use Commas as decimal points. The actual problem is that excel doesn't know how to align numbers when opening text files. Can any one help? I use Excel 2000 o Excel 2003. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Col alignment problem
Hello newbie,
Are you opening the text file with vba or by hand? If by hand, your Data | Text to Columns | Delimited may not be cleared out. If by vba, consider: Workbooks.OpenText FileName:= "MyFileName.txt", Origin:=xlMSDOS, _ StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlNone, _ ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:=False _ , Space:=False, OTHER:=False, FieldInfo:=Array(1, 1) Hope that works for you. Good Luck. -- Thx MSweetG222 "newbie in hell" wrote: Suppose I have a text file like this Name Wage Robert 123 John 111,34 Mike 222,55 When I open the text file I get on Excel: Name Wage Robert 123 John 111,34 Mike 222,55 Notice that we use Commas as decimal points. The actual problem is that excel doesn't know how to align numbers when opening text files. Can any one help? I use Excel 2000 o Excel 2003. Thank you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Col alignment problem
When you open the text file you should get the Text Import Wizard pop.
In step 3 under Column Data Format select Text for the second column. Gord Dibben MS Excel MVP On Thu, 22 Feb 2007 14:40:58 -0800, newbie in hell wrote: Suppose I have a text file like this Name Wage Robert 123 John 111,34 Mike 222,55 When I open the text file I get on Excel: Name Wage Robert 123 John 111,34 Mike 222,55 Notice that we use Commas as decimal points. The actual problem is that excel doesn't know how to align numbers when opening text files. Can any one help? I use Excel 2000 o Excel 2003. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alignment problem with spreadsheet | New Users to Excel | |||
vertical text alignment problem when printing | Excel Discussion (Misc queries) | |||
Problem with OWC11 cells alignment from C# | Excel Programming | |||
Command Button Alignment Problem | Excel Programming | |||
Text format alignment problem | Excel Programming |