Hi,

CVS file doesn't inlcude information about formatting. So eventhough if you
change the cell formatting to text and enter e.g. 000555555 the leading zeros
will be lost. The workaround is to write the phone no. maybe like this (000)
555-555 or enter some char before the zeros.

--
http://blog.jausovec.net

"HarCo" je napisal:

When I open a csv file in excel any preceding '0' will disapear. How can I
see the data exactly as it is in the csv\text file? (e.g. if my data contain
telephone numbers with area code that has preceding '0' it will be removed).