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.
|