Yep. Excel likes to help. It's sometimes (usually???) irritating.

I would import an ASCII file and want to make sure a column was treated as
text. Then insert that adjacent column and have to remember to change the
format back to General.




wrote:

Hi Dave,

I just noticed that the cells have a "text" format when their column is
inserted NEXT TO a column with "text"-formatted cells. However, the
cells have a "general" format when their column is inserted a few
columns AWAY FROM a column with "text"-formatted cells.

gary

--

Dave Peterson