When I open the format cells dialog (checking that the general format is
applied to the formula cell), the 'sample' area displays the value correctly,
exactly as I want it to appear in the cell....but the formula is what's
displayed.

"jgoetter" wrote:

No change after ensuring all formats are general & re-entering formula -- the
formula is still displaying rather than the value (which is displaying
correctly in the cell I'm referencing in my formula)

"Niek Otten" wrote:

The cell was formatted as text when you entered the formula. Format as
General AND re-enter the formula (F2, ENTER); just reformatting is not
enough!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"jgoetter" wrote in message
...
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.