Thanks for the tip...now I have a question...I am using this formula now in a variety of instances, and have come across the following problem-
In one instance, I am bringing the values from two separate cells into the same cell as explained- one is a plain number, and the other is a %. The thing is, when i bring them together, the % loses its format (ie- it doesn't read 4.01%, it now reads .0041) I can't simply format the cell, b/c it will change the other figure into a %, which I do not want. Is there any way I can only format the second value I am bringing into the cell?
Also, another problem I am running into has to do with a web query- I am pulling another piece of info from another sheet in similar fashion, but the problem is that this number changes from a date to a plain number throughout the day. Thus, the cell to which I am referencing it needs to be formatted in a way in which it recognizes this and formats accordingly (formats date when a the cell shows a date, and formats a plain number when it shows a regular number) Don't know if this is confusing or if anyone can help...Thanks!