Hello,

I have helped a friend with setting up a spreadsheet on his laptop. He has a HP Pavilion Entertainment PC, Model # dv5 -1225ca. His operating system is Windows 7 Home Premium.

The first column on his spreadsheet has been formatted to accept a date in the format of mm/dd/yy.



When he enters a date, in most cells, if the format is correct the date moves to the right. In some cells, the date will move to the left even though the format is correct.

I have checked the format for those cells and it is the correct format. I have tried removing/resetting the formatting, saved the worksheet, closed down Excel. Then restarted Excel, changed the format and the cells still act in the same way.

Any suggestions what might be causing this issue?

Thanks

DD