Re: Format on New Database Query


Hi,

Thanks for the response. I am trying to retain formulas. The
properties window doesn't mention anything about formulas. When I
think of formatting, I think of font color, etc...

But what I would like is for the data to be TRIMmed, Concatenated, and
have NULL entries replaced w/ NA.

Moreover, I am hoping to impose those formulas on import/refresh. This
way I don't have to apply the same silly formulas day-in day-out.

Thanks,


--
fncuis
------------------------------------------------------------------------
fncuis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26466
View this thread: http://www.excelforum.com/showthread.php?threadid=397329

.