I have the little green triangle in any cell that contains a formula. This is on a sheet that I designed on the windows 2007 excel then moved over to the mac. In reviewing the formula problems or errors I see that it has to do with div/0. I am puzzled as to how to fix the formula so the green triangle does not appear.
excell formula problem
- Thread starter jerber
- Start date
sgould
Registered
Not sure how it would affect DIV/0 but I recently had a major problem importing an Excel file. My problem lay with the base date for counting the days that calculate dates.
Some versions use 1904 as "Day zero" and others use 1900. So all my dates were 4 years out after transfer. But I got no error triangles.
But have you got any times in the sheet? If you don't specify a year it defaults behind the scenes to 1900 or 1904.
Some versions use 1904 as "Day zero" and others use 1900. So all my dates were 4 years out after transfer. But I got no error triangles.
But have you got any times in the sheet? If you don't specify a year it defaults behind the scenes to 1900 or 1904.