Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
exported Outlook contacts to an Excel file - finding unwanted ' sy
I have exported Outlook contacts to an Excel file. I run in to a problem
that the data in each cell now has a ' symbol placed at the beginning of the data. It prevents me from formatting the data, such as setting numbers to a phone number format. I have not found a method to remove the symbol without opening each cell and manually deleting the symbol. Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
exported Outlook contacts to an Excel file - finding unwanted ' sy
Export the file as CSV instead. I think
that takes care of the apostrophe. -- Regards, Peo Sjoblom "TYM" wrote in message ... I have exported Outlook contacts to an Excel file. I run in to a problem that the data in each cell now has a ' symbol placed at the beginning of the data. It prevents me from formatting the data, such as setting numbers to a phone number format. I have not found a method to remove the symbol without opening each cell and manually deleting the symbol. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
export from 07 excel to outlook contacts | Excel Worksheet Functions | |||
How can I email an excel file using my outlook contacts? | New Users to Excel | |||
Selected Outlook contacts to excel | Excel Discussion (Misc queries) | |||
Import Excel File to Contacts in Outlook | Excel Discussion (Misc queries) | |||
How do I share excel contacts with outlook? | Excel Discussion (Misc queries) |