I have just converted worksheet version 2003 to 2007. Some of the value format changed to date format and the lines and formating no more there. I have reformat the WS and change back to value but somehow after I reopen my WS some of the cells will change back to date format the lines are missing. Can anyone help!