Hi,

In addition to John's point when you have re-formatted as general it still
won't work until you re-enter the formula so with the cell still selected tap
F2 and press enter.

Mike

"John Bundy" wrote:

Try formatting the column with the formula to general.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"jgoetter" wrote:

I am concatenating (6) text string cells values into a single/summary cell
(H12) on Sheet1 -- then want to display this summary cell value on Sheet2.

I am using the formula ='sheet1'!H12 in the Sheet2 cell -- but the formula
is displaying rather than the actual value of the sheet1 H12 cell.

The formula works fine for me in other situations using numbers -- but am
having trouble displaying the values in this text situation. Am on Exel 2003.