View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
newbie in hell newbie in hell is offline
external usenet poster
 
Posts: 5
Default 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.