Changing and keeping format

Hi everyone.I have a problem that I can't fix.On my spreadsheet I have a column(7.65462E+11) it's a upc code.I can format the column to read as a number (value) but when I save it I does not save the number format.It's really interesting that there are some rows that read exactly the same and those rows keep the number formatting.Going nuts.Also when I try to save a date format(2013-mm-dd) It won't save,I've read that it's system default in U.S,is there a way around that ?

Thank You

Try downloading, opening, and saving the attached workbook.

Does the format remain stable for you??