| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell in copied worksheet displays formula and not value
I have a problem I just cannot correct.
I have an excel file that contains a number of work sheets that were copied form other worksheets in the same file. Some of the dells in those worksheets display the formula rather than the value. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell in copied worksheet displays formula and not value
These cells may have copied as text
select the cell Format|Cells and select general Tap F2 Tap enter Mike " wrote: I have a problem I just cannot correct. I have an excel file that contains a number of work sheets that were copied form other worksheets in the same file. Some of the dells in those worksheets display the formula rather than the value. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell in copied worksheet displays formula and not value
Format all to General then select a cell showing the formula.
F2 then ENTER If you have many of these try Selecting a range and Edit/Replace What: = With: = Replace all. Gord Dibben MS Excel MVP On Thu, 7 Feb 2008 11:11:24 -0800 (PST), wrote: I have a problem I just cannot correct. I have an excel file that contains a number of work sheets that were copied form other worksheets in the same file. Some of the dells in those worksheets display the formula rather than the value. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula displays in cell | Excel Discussion (Misc queries) | |||
| Formula Displays in One Cell | Excel Worksheet Functions | |||
| Formula Displays in One Cell | Excel Worksheet Functions | |||
| cell displays formula | Excel Discussion (Misc queries) | |||
| Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions | |||
Hybrid Mode
