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