I am really hoping that some one can help me. I have been working on a series of workbooks that are tied together and I thought that I had it all worked out but now it's starting to reformat cells at random. This project consists of 5 workbooks and they are all pretty similar in formatting and design. At the top I have a section that is set to have the name of certain type of training in cell "G2" and then how many months the training has to be repeated in cell "G3" and it continues like that across the top of the worksheet. Then there is a list of all the people in my unit and below that there is a list of the number of people trained in cell "H38" and then the percent trained in cell "H39". Now the problem that I am having is that Excel is randomly reformatting the data in cells "G3" and "H38" so that it will appear as dates rather than numbers (with 0 digits after the ".") or as General. If this had only happened once then I would have chaulked it up to user error of some kind or another (the cells are locked so that they can't mess with them), but since it has happened a second time and this time was on my watch, I really have no idea what is going on. It is a big pain to go back and change it again since each workbook has 7-8 worksheets and each worksheet is locked.
If anyone has any advice on how to make it so that this will stop doing this I would greatly appreciate your help.
John
If anyone has any advice on how to make it so that this will stop doing this I would greatly appreciate your help.
John
