Apache OpenOffice Community Forum

I have a number of spreadsheet files that were initially created in excel. Recently i started using open office and there seemed to be no disruption viewing on the computer until i tried to view the same files on numerous apps on my iphone. There the date appears as the designated number for that day of the year... Ex; todays date is nov. 28, 2012, =date(12;11;28), but it shows up on the iphone as 333-nov. Does anyone know how to correct this issue?

Please don't shout. Changed capitalization from all caps to sentence case. Moved to Calc forum - floris v, moderator