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