Sims Report in Word/Excel changes date format
Anyone else had this problem. Where you have a report in Sims it aims to give for instance, forename, surname and dob. You look at the preview and its all looks fine the students date of birth is in the format of something like 27/09/1996 yet when it gets put into work or excel (Office 2010) it puts it in the format 27 September 1996.
Anyone know how to stop it doing this ? it may just be a word/excel setting but i cant find it ...
Edit : I found this for excel > Options -> Advanced -> (check box on) Transition Formula Entrys (all the way down at the bottom). however that does actuive sheet and not the ones that come out of sims.... although this option doesnt exist in word.