I prepared a software in Microsoft Access 2007 that export a query result to Excel. The data in Excel is fine, but I need a text column that includes the apostrophe at the beginning of the field but that apostrophe should not be visible in the cell but it should be visible in the formula bar.
If I try to add the apostrophe in the query (creating an expression field and concatenating the apostrophe with the value of the field) before exporting to Excel, the apostrophe appears in the formula bar and also in the cell. I cant permit that because this spreadsheet will be imported in a system which requires what I looking for.
Thanks in advance.