The ' happens because the underlying queries have formatted fields. That
forces Excel to force them to text with the '. I'm trying to get around
having to duplicate the queries that are formatted to display data in a
form, with redesigned queries without the formatting to export to Excel.
This would create a maintenance nightmare in my db. I have several forms
whose underlying queries are exported to Excel and I'd like to use them
"as is" for my exports. Otherwise, any change to a form query will
necessitate a change to it's export counterpart.


--
ragtopcaddy
------------------------------------------------------------------------
ragtopcaddy's Profile: http://www.excelforum.com/member.php...o&userid=25838
View this thread: http://www.excelforum.com/showthread...hreadid=535577