Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
disappearing zeros in front of my CSV file.
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to display numbers with zeros in front of them, eg 005 | Excel Discussion (Misc queries) | |||
how do i keep zip code zeros from disappearing | Excel Discussion (Misc queries) | |||
add zeros in front of numbers | Excel Discussion (Misc queries) | |||
How do I keep leading ZIPcode zeros from disappearing in Excel? | Excel Worksheet Functions | |||
How do I create a macro to add zeros in front of a value? | Excel Worksheet Functions |