Preserving Cell Formats in Excel Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am doing queries on a large workbook of multiple Excel spreadsheets. When I query the data, the original data formats don't carry through to the query results. Is there a way to carry original formatting through to Excel Query results

Any insight would be appreciated

Karen S
 
No, you can import the data, but not the formats. If you're importing
programmatically, you could apply the formatting as part of the import
procedure.
 
Thank you, Debra, for responding

Even though it wasn't what I wanted to hear......

Karen S
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Query from Excel - Preserving formatting, validation and Commen 2
Counting multiple memberships 1
Preserved cell formatting 1
Pivot Table formatting 2
Maintaining Cell Format in Query 2
Access query results to Excel 3
Excel Query setup 0
Access #Error & Excel Pivot 0

Back
Top