Apparently not. When I create the query, the values are converted to "General" formatting. I can apply "Date", "Percentage" and "Currency" but that puts me back in the same position before I started. I need the values to be "text" formatted as long dates, percentages or currency.

Will attach a sample file if you think you can help. Thanks

Attached Files

Data Formatting Demo.xlsx (22.3 KB, 3 views)

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/