| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Changing what is displayed in the formula bar
Select B10. Pull-down Edit Copy. Pull-down Edit Paste Special as value.
-- Gary''s Student "Christina L." wrote: Is there a way to change what is displayed in the formula bar. E.g. Cell B10 contains a number. This number is the result of a formula. The formula bar displays the formula. Can the formula bar display the number that is contained in cell B10 and not the actual formula? Thanks -- Christina L. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding row to forumla | Excel Discussion (Misc queries) | |||
| How do I move data without changing an associated formula? | Excel Discussion (Misc queries) | |||
| Changing the Color of a Word in Formula | Excel Worksheet Functions | |||
| How do I keep a formula from changing if a row is added or deleted | Excel Discussion (Misc queries) | |||
| How do I keep a formula from changing if a row is added or delete. | Excel Discussion (Misc queries) | |||
Threaded Mode
