Excel

Hi Monika, I use 2003 but the solution should be the same. I think you have your number col/cells set to Date. Select the col/cells you want as numbers, right mouse, select Format cells, then Numbers then select General.
what you have at the mo' is this or something like it, yes/No?

21/06/1916
21/06/1916
21/06/1916
After doing the above or the equivilant in 2010 you will have
6017
6017
6017

Hope it works for you

Baz