Excel 2003 cell formatting

When trying to format cells in Excel 2003 the command seems to be ignored ie, when changed to General it drops the starting 0 in number strings, like it should in Number format. Am I missing something because it is phasing me with regards to the general reliability.