Change Number Format Conditionally

Hi,

Is there a way to change the number format of a cell conditionally, without converting it to text?

I'm using a number of nested "if" statements to get data from different tables. The data could be an integer, a percentage, or a time measurement, and I'd like the data to automatically display in the appropriate format when changes are made. I'm using Excel 2000.

Thanks,
Christiaan

You can display a number in a format based on a calculated condition using the TEXT function:

=text(someFormula, if(a1 > 2, "0%", "#,##0") )

... but the results will indeed be text. With a little caution, though, such text-formatted numbers can still be used for downstream calculation.

Thanks for the help.