Since both Monarch v5 and v6 are capable of exporting to Excel 8.0 format, the format compatible with the most recent versions of Excel (XP/2002), your default value for .xls file export is probably set too low.
Go into "Options" - "Folders and File Types" - "Export File Types" - "XLS Files," and be sure that the setting is for Excel 8.0. Right now, I would guess it is set to Excel 5.0 or lower.
In the same vein, you should generally set all of your export file types to their highest listed values. If you have MS Access 2000 or XP/2002, then set the export type to Access 4.0. However, if you have only Access 95 or Access 97, then set it for Access 3.0. This setting refers to the MS Jet Database Engine version being used.
Give us another post if your format problem doesn't go away. Good luck!
[size="1"][ February 20, 2003, 03:10 PM: Message edited by: Tom Whiteside ][/size]
I have the same problem - I think the apostrophe is a "non printing character". It's really annoying as it screws up a lot of follow up work in Excel. The only solution I've found so far is to export the data as Excel 2.1 format as the apostrophe isn't picked up. But of course this is a backwards step in other respects.
Anyone got the real solution?
Apostrophes in Excel:
This is a known issue with the Microsoft Jet Engine. Microsoft has addressed this issue with the following code. If you run this code as a macro within Excel it will remove the hidden apostrophes. Set fields to text format or leading zeros will be lost in fields.
' Removes hidden apostrophes as first character
' Works on formulas as well as text and values
For Each CurrentCell In Selection
If CurrentCell.HasFormula = False Then
' Checks to make sure that procedure does not
' change cell with a formula to be only the value
CurrentCell.Formula = CurrentCell.Value