T
TomHinkle
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?
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?