Ever since I have started using Excel 2007 now and then Excel views
the formula as a text string, not a formula.

For instance, today I entered =if(m2L2,"Jan"," ")
The formula just stayed as entered on the screen, ie, it didn't
execute the formula. When I opened a new workbook and entered the same
formula it worked without any problems.

By the way I am saving the files as Excel97-Excel2003 compatible.

Any suggestions on what I am doing incorrectly.

Thanks

Don