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? |
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? |
All times are GMT +1. The time now is 09:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com