G Guest Oct 4, 2006 #1 When exporting data from Reports to Excel , the data is not properly formatted.
J Jeff Boyce Oct 4, 2006 #2 Vineet Create a query that returns the data. In the query, use the Format property and function, and the "conversion" functions (CDate(), CInt(), etc.) to coerce the data to be in the format you wish exported. Then export the query. -- Regards Jeff Boyce Microsoft Office/Access MVP Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/
Vineet Create a query that returns the data. In the query, use the Format property and function, and the "conversion" functions (CDate(), CInt(), etc.) to coerce the data to be in the format you wish exported. Then export the query. -- Regards Jeff Boyce Microsoft Office/Access MVP Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/
