import CSV with a text field starting with 0

R

rlewing

Hi,

I'm trying to read a (java generated) CSV file into excel
which has a field containing a text which often begins
with character "0" (zero) or with character "+". Excel
seems to understand these text values as numbers and
strips the leading zeros and plus signs. If I add a
'-sign as first character in the field to indicate that
this should be understood as text, it remains visible.

How to tell excel to treat this field as text?

I appreciate any help

Thanks
 
W

whisperer

If you use the Import wizard it will offer you the opportunity to
determine what type of cells go in each column.
 
Top