View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Why is the formula displaying rather than the actual value?

Glad you got it working eventually!
So, Shane was right, difficult to read on the forum

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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