General discussion
June 19, 2006 at 05:27 AM
hunterzh

Question on convert data type in Excel

by hunterzh . Updated 20 years, 3 months ago

Now we have an Excel file, I need to convert one column of data into Text format. Originally, the column is in custom format “000000-00”, looks like 060414-26; how can I convert it directly into Text with exactly same result. I?ve tried to change the format of cells directly into Text, but then it looks like 6041426, not 060414-26.

This discussion is locked

All Comments