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.