Home |
Search |
Today's Posts |
#1
|
|||
|
|||
display values of formulas in Excel
I am using Excel 2002 to link two workbooks. In destination, I got the
formulas instead of values for all columns pointing to constants (text format), and values for other columns pointing to cells containing numbers. All of them are linked to the same workbook in the exactly same way. And I have tried Ctrl+`, but it only widen the columns for me (I do not know why). Could any guru please help for this? |
#2
|
|||
|
|||
Binyaaust,
Do not format the cells for text, even if you are expecting the formulas to return text. Format the cells for General, and re-enter the formulas. Text formatting forces anything entered into the cell to be text - which is why you see your formula. Applying the General format after entering the formula into a cell formatted as Text won't do anything - you need to re-format and re-enter. HTH, Bernie MS Excel MVP "Binyaaust" wrote in message ... I am using Excel 2002 to link two workbooks. In destination, I got the formulas instead of values for all columns pointing to constants (text format), and values for other columns pointing to cells containing numbers. All of them are linked to the same workbook in the exactly same way. And I have tried Ctrl+`, but it only widen the columns for me (I do not know why). Could any guru please help for this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I summarize totals for a list of values in Excel? | Excel Worksheet Functions | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
How do I display records using a key field in Excel? | Excel Worksheet Functions | |||
How do I get to master Excel functions and formulas? | Excel Worksheet Functions | |||
delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) |