| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
force evaluation of text
In cell A1 I have the value B and in cell A2 I have the value 6.
I want cell A3 to have the value of cell B6. I can get A3 to read B6 but no to give me the value that is sitting in B6 (3512). Is it possible to force the evalution of A3 (currently =A1&A2) Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel save as csv - force text qualifier on every text field | Excel Discussion (Misc queries) | |||
| How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
| dates and text | Excel Discussion (Misc queries) | |||
| Force values-only when pasting text to keep formatting | Excel Discussion (Misc queries) | |||
| Cell text based on 4 condition test | Excel Worksheet Functions | |||
Threaded Mode
