Hi fncuis,

If you're using a Database Query from the Data menu, then you can
right-click the querytable and select Data Range Properties. Make sure
Preserve Cell Formatting is checked, and look for any other options that may
help you retain your formatting. Sometimes, I will put my querytable on a
hidden worksheet and have another, "presentation" worksheet that massages
the data into the format I want the users to see.

If you're not using a Database Query, then please explain how the data is
getting put into Excel, and we may be able to assist.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


fncuis wrote:
Hello Everyone,

I am connecting through Excel to my company's business software via
ODBC.

The data that comes out of our business software, well... to say the
least, its not very database friendly. Lots of spaces, ALL CAPS
(ugh), and requires concatenation on multiple columns.

The data I import will be refreshed nightly from the software, so
naturally, when i open up excel, and refresh, its right back to the
raw, unformatted data.

I would like to know if at all possible, a way to "lock-in" my
commands and formatting, so that when I do refresh the linked data, I
automatically impose my formatting on it.

Can someone point me in the right direction?

Thanks,