Date and time

Hi Jaimie, Thank your for your post, welcome to the forum, in answer to your question; this is a formatting problem, you must change the answer cell format to that which you require ie dd/mm/yyyy hh:mm right click on the cell, choose Format and Choose the Number tab, Select Date and make your choice from the options available, or go to Custom and type your required custom format. A quick fix would also be to click on one of your previously set up cells, then to click the Format Painter button (little yellow paintbrush) on the Standard toolbar and then click on the cell with the number in it, thereby changing its cell format. I hope that has helped, if so please click the Resolved link, best regards Pete