Excel 2007 : Format changes when closing the excel

[darkhangelsk]

Hi,

I just encountered 1 problem using the Excel 2007, I don't know if it is a bug or in the Excel options. Here it goes, - in A2:A34 (actually even other rows or columns) with the date formatted as "mm/d/yyyy" will change everytime i closed the excel and re-opened it. The font also changes, I formatted it as Calbri font size 11 but when i closed it and re-opened it the format changes to Arial 12,. I saved it as Excel 97-2003 compatibility mode. I hope someone can teach me how to solve this problem.

Thanks!

[broro183]

hi,

What file format are you saving it as, (eg .csv, .xls, .xlsm...?)
If it is .csv or another text format, the date format will always be removed because as the Excel 2007 Help files state:

Note If you save a workbook in text format, all formatting is lost.

(press [F1] & search for "file formats")

Are there any macros in the file?
Or, do you have any other files open at the same time which have macros in them?

in A2:A34 (actually even other rows or columns) with the date formatted as "mm/d/yyyy" will change everytime i closed the excel and re-opened it

What do the cell formats change to?

hth
Rob