open csv file, display format
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!!)
|