sounds like a cell format issue. go to home tab and change cell format to Number and adjust # of decimal places to 0 and you should get 56 in that case. excel basically got it in its head that you are trying to put a date in that cell and you just have to tell it that it is a number not a date