Hello all,
I have been creating a workbook for my daughter to record sales info. I finished it yesterday and sent it to her as an email attachment.
One of the sheets has order numbers (eg. BB001, BB002 etc.) in column A, and the cells are formatted as TEXT. The problem I have is that when she clicks on a Row Number, say to highlight the whole row, or to insert a new row, the Order Number immediately changes to a the Current Date.
I have no idea why this is happening as we are both using Excel 2007 and this error does not occur on the original workbook which is saved on my computer.
As I don't know what is causing the problem, I am struggling to research the issue in order to find a solution.
Any assistance would be graciously appreciated.
Rob.
Bookmarks