Why do the 0 in front of phone numbers get removed when I save a csv file?

by on December 22, 2010

Q: In a csv file I need a 0 prefix next to all phone numbers. When I save it disappears. How can I make it stay?


One Response to “Why do the 0 in front of phone numbers get removed when I save a csv file?”
  1.  
    Picked as best answer

    Simply type an apostrophe and then the zero before the other numbers. The apostrophe lets Excel know that you want to keep the number formatted as text and thus keep the leading zero.

    Read more: How to add leading zeros in Excel | eHow.com http://www.ehow.com/how_4703826_add-leading-zeros-excel.html#ixzz18w1zYCl3