Open office calc
Dec. 16th, 2008 06:55 pmIn excel, if you set the date format of a cell to be DD/MM/YY, then when you type in, for example, 8-12 it assumes you put it in in the format you are using. So you get the eight of december. In open office it assumes you type your daes in like an american and ignores the formatting you have chosen, so you end up with the twelfth of august. Is there any way to fix this?