Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is the formula displaying rather than the actual value?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is the formula displaying rather than the actual value?
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is the formula displaying rather than the actual value?
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is the formula displaying rather than the actual value?
I did try that already, on both worksheets...
"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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is the formula displaying rather than the actual value?
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is the formula displaying rather than the actual value?
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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is the formula displaying rather than the actual value?
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. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is the formula displaying rather than the actual value?
are any other formulas showing? you might hit Ctl+` to see if it changes it.
If not you are welcome to send it to me and i can take a look. -- -John Please rate when your question is answered to help us and others know what is helpful. "jgoetter" wrote: I did try that already, on both worksheets... "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. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is the formula displaying rather than the actual value?
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. |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is the formula displaying rather than the actual value?
Hi,
On these forums its hard to read Ctrl+` So instead choose Tools, Options, View and uncheck Formulas Ctrl+` is the Control key with the unshifed ~ key, which is usually at the left of the 1 key on the top row. If this helps, please click the Yes button Cheers, Shane Devenshire "jgoetter" wrote: 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. |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is the formula displaying rather than the actual value?
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. |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add the actual value in a cell that contains a formula | Excel Discussion (Misc queries) | |||
Currency format for Excel 2007 not displaying actual number | Excel Discussion (Misc queries) | |||
Formula results to actual value | Excel Discussion (Misc queries) | |||
what is the 1 minus in this formula actual doing | Excel Worksheet Functions | |||
formula for month that is prior to actual | Excel Worksheet Functions |