Number formatting

[Guest]

I have a spreadsheet where the number format in column F keeps changing back
to short date format when it gets re-calced..

The formula isn't complex.

= IF(C3=0,0,E3/C3)


C3 and E3 are formatted as general numbers. everytime the sheet calc's,
Column f (which should be formatted as %,) goes back to m/d/yyyy format.

Very strange..

Any ideas?

 

[Guest]

Suggest you try the formula:

= E3 / (C3+0.00001)

 

[JE McGimpsey]

Do you have any event macros running that change the format?