Hello ptmuldoon,

When a cell is formatted as Text, Excel will not evaluate the contents of the cell. Either you will have to change the cell's format to General or use VBA to paste the value into the cell.

Since I failed to understand your example as you intended, I suggest you submit a workbook with before and after examples.