I'm running Windows Vista on a Dell XPS 410 desktop with Excel 2007. I need to enter numbers starting with zero in the column field and they when I leave the cell, so do those zeros. I have set that column to text and the zeros remain but as soon as other activity goes on, it appears that Excel defaults to removing those beginning zeros again and I have to change the settings each time in the number group to text or use the format painter to copy a cell where the zeros remain intact.
Is there a way of setting the defaults so that the beginning zeros remain unless I change the settings? This is a big nuissance and I assume there's an easy fix but I can 't find it.