| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copy formula so destination displays formula as text
Cell C123 contains the value 99.
I want cell A1 to display that value (99) and cell B1 to display the formula (=C123). I put =C123 in cell A1. What do I put in cell B1? I know I can toggle between value and formula but how do I get them to both display side-by-side at once? THANK YOU! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Mass Copy??? | Excel Discussion (Misc queries) | |||
| reminder notifications in a column | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How to copy cells with keeping exact formula intact | Excel Discussion (Misc queries) | |||
| When I copy down into the next cell the formula changes correctly. | Excel Discussion (Misc queries) | |||
Threaded Mode
