Preserving Cell Formats in Excel Query

K

Karen S

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
 
D

Debra Dalgleish

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.
 
K

Karen S

Thank you, Debra, for responding

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

Karen S
 
Top