in my csv file, there is a string '123', but when open it, Excel treat it as
numeric and so use right alignment, any method to force Excel treat it as a
string? (I have try to pad some space character before and after the string
'123' but it still doesn't work!!)

You need to invoke the import wizard:


Just re-name your file from .csv to .txt before you open it. Tell the
import wizard that the field is text
--
Gary's Student


"kei" wrote:

in my csv file, there is a string '123', but when open it, Excel treat it as
numeric and so use right alignment, any method to force Excel treat it as a
string? (I have try to pad some space character before and after the string
'123' but it still doesn't work!!)

Thx Gary's student,
I've found another method now, just use "=" to enclose the numeric string,
e.g. "=123", then when Excel open the .csv, it will treat it as String!!

"Gary''s Student" wrote:

You need to invoke the import wizard:


Just re-name your file from .csv to .txt before you open it. Tell the
import wizard that the field is text
--
Gary's Student


"kei" wrote:

in my csv file, there is a string '123', but when open it, Excel treat it as
numeric and so use right alignment, any method to force Excel treat it as a
string? (I have try to pad some space character before and after the string
'123' but it still doesn't work!!)