Using Outlook 2003 on a Vista Business system i want to export some of my
contracts to Excel 2003.

The export works great but when going into Excel each cell with a value has
a ' in front of the value. I would have to delete that special character
from each of the cells.

How can I do the export without the '?

"Gerd" wrote in message
...
Using Outlook 2003 on a Vista Business system i want to export some of my
contracts to Excel 2003.

The export works great but when going into Excel each cell with a value
has a ' in front of the value. I would have to delete that special
character from each of the cells.



In Excel just do a "Find" and Replace with nothing.

I already tried that. I had copied the special character and pasted into the
find search field. However when doing a replace or replace all I get a
message that nothing has been found.

I don't see the that character on the spreadsheet but when clicking on a
cell with a value I see it in the formular bar. If I click next to that flag
in the formular bar the flag also becomes visable in the cell. And removing
the flag shifts the cell value to the left.

Any other ideas?

"Gordon" wrote in message
...
"Gerd" wrote in message
...
Using Outlook 2003 on a Vista Business system i want to export some of my
contracts to Excel 2003.

The export works great but when going into Excel each cell with a value
has a ' in front of the value. I would have to delete that special
character from each of the cells.



In Excel just do a "Find" and Replace with nothing.

The behaviour your are seeing is not related to Outlook but rather is a
function of the Excel driver used to create the file (ergo - doesn't matter
what program creates an Excel file using the Microsoft Excel driver - the
same thing occurs).

Quickest/simplest solution - save your output to a CSV file and then open
that in Excel.

Karl
__________________________________________________ _
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com



"Gerd" wrote in message
...
Using Outlook 2003 on a Vista Business system i want to export some of my
contracts to Excel 2003.

The export works great but when going into Excel each cell with a value
has a ' in front of the value. I would have to delete that special
character from each of the cells.

How can I do the export without the '?

Thanks Karl, that did the trick. I had already tried space delimited but
that did not import into Excel well.

"Karl Timmermans" wrote in message
...
The behaviour your are seeing is not related to Outlook but rather is a
function of the Excel driver used to create the file (ergo - doesn't
matter what program creates an Excel file using the Microsoft Excel
driver - the same thing occurs).

Quickest/simplest solution - save your output to a CSV file and then open
that in Excel.

Karl
__________________________________________________ _
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com



"Gerd" wrote in message
...
Using Outlook 2003 on a Vista Business system i want to export some of my
contracts to Excel 2003.

The export works great but when going into Excel each cell with a value
has a ' in front of the value. I would have to delete that special
character from each of the cells.

How can I do the export without the '?