I know how to create a template with customized features and formats for when
I create a new workbook or worksheet, but these customized setting do not
seem to apply when I open a file.

I am trying to figure out how to change the default number format when I
open a CSV file. I do want it to be scientific with six significant decimal
places, but I can't seem to figure out a way to do this. I have read quite a
few books and spent several hours searching the internet, but I have come up
empty handed.

How can I accomplish this. By the way, I am running Excel 2003 right now
but upgrading to Excel 2007 next week.
--
chris.bowers