Cell A1 displays the output of various different cells on a worksheet, however the information in the other cells can be formatted as either a number or as a percentage, e.g. Cell C1 may = 23,452, where as Cell D1 may = 79.23%.

How can I maintain the correct format for the figure displayed in Cell A1, i.e., when A1 displays the contents of C1, I want it to display as a number and when A1 displays the contents of D1, I want it to display as a percentage without having to change the cell format for cell A1? I want cell A1 to display 79.23% and not 0.7923!