Number formatting
 

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?

Suggest you try the formula:

= E3 / (C3+0.00001)

"TomHinkle" wrote:

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?

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

In article ,
TomHinkle wrote:

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?