Hi all,

I have a list of numbers which I want to convert to dates.

I thought if I just went to 'format cell' - 'date' it would change it but it converts it to a random number.

e.g. the number in the cell is 130601, which is June 1, 2013 bu when I try and change the cell format to 'date' it brings back '2257-07-27'

Is there another way to edit this? I feel like I am missing something simple?

Thanks