open csv file, display format

K

kei

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!!)
 
G

Gary''s Student

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
 
K

kei

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!!
 
Top