?
Solved

Address Book Exports

Posted on 2013-06-28
2
Medium Priority
?
355 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
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

Free tool for managing users' photos in Office 365

Easily upload multiple users’ photos to Office 365. Manage them with an intuitive GUI and use handy built-in cropping and resizing options. Link photos with users based on Azure AD attributes. Free tool!

Question has a verified solution.

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

Today as you open your Outlook, you witness an error message: “Outlook is using an old copy of your Outlook Data File…”. Probably, Outlook is accessing an old OST file.
Let us take a look at the scenario, you have a database that is corrupt and you run the ESEUTIL command only to find you are unable to repair it. How do you now get the data back?
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
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…

601 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