View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default disappearing zeros in front of my CSV file.

Open your CSV in Notepad to see whether you've got the leading zeroes in
there.
Remember that a CSV is a TEXT file. If you want to see the text in the CSV
unchanged, don't just open the CSV file in Excel, as Excel will treat
anything it thinks is a number as a number. If you want to read the data
into Excel, invoke the text import wizard by either changing the extension
from CSV to TXT before reading the file, or by using Excel's Data/ Import
External Data. Then specify the format of the relevant columns as text
during the import.
--
David Biddulph

"Boetfaas" wrote in message
...
How do i stop the zeros in front of my tel numbers disappearing? when i
import my tel list then all the numbers are wrong, pretty anoing..

Thanks