Thank you all for your help. I was doing CTRL+apostrophe rather than the
tilde key.
Kind Regards,
Jacki G


"Niek Otten" wrote:

Then follow John's advice: hit CTRL+`

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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