What's the name of the file you import?

If it ends with .csv, change that extension first.

..CSV files get to ignore that VBA code.

solomon_monkey wrote:

Okay, this is bizarre- I can record the macro- it all works fine... the
cells are all good... I run the macro and it changes the formatting
around!!??
Is there some setting within Excel that I have active maybe??

--

Dave Peterson