I import a table from sql server to Excel occassionaly,

I need to format one column in Excel file.

For example, I need to replace numbers in the column with a text,
with weekly, 1 with daily, 16 with monthly etc, 4 with daily etc,

Everytime I get the new file, I have to do it use replace dialoge bo
on the edit menu to do all the replace,

Are there some easy ways to do this, or at least I can save thos
functions so that later I can use it again, instead of doing replac
for each one manually.



Thank

--
xca
-----------------------------------------------------------------------
xcao's Profile: http://www.excelforum.com/member.php...fo&userid=1453
View this thread: http://www.excelforum.com/showthread.php?threadid=26322