Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Address Book Exports

Posted on 2013-06-28
2
Medium Priority
?
348 Views
Last Modified: 2013-06-30
Hi

Say,

Our export contacts from the address book in outlook to CSV file. When i open them in excel (2010) - the numbers with a leading 0 are truncated to the 1 digit greater that the 0. e.g. 011 345 6789 becomes 11 345 6789. How can i edit the CSV file without this happening? To be safe, how can i preserve the formatting and still manage to edit it in excel?
0
Comment
Question by:shaunwingin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 9

Accepted Solution

by:
TvMpt earned 2000 total points
ID: 39283718
0
 
LVL 1

Expert Comment

by:aman_vijay
ID: 39283721
i think you can change the category of that specific column ... by selecting that column and then changing category of that column to general....

 at last i can't guarantee you the success, as i don't know which type of data and csv file you are opening in excel, so please keep a back up copy first.

select the specific column
change category here... to general
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
In this article I discuss my selections of the Top Four free Outlook OST File Viewers available. Open, view and read even damaged OST files by using these tools. They all provide a clear preview of all data such as emails, notes, tasks, calendars, e…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question