Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I convert cells containing formulas to text (value returned
Is there a way to convert the data returned from a formula to text and remove
the formula? For example, I have a cell containing this formula: =IF('Current Registrants'!F5="yes", 'Current Registrants'!J5, 0). After the value has been returned, I would like to convert that cell to the return value & get rid of the formula. Is this possible? Thank you for your suggestions. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
How do a convert a "text only (no formulas)" Excel (.xls) file to. | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Need to convert text string to seperate cells | Excel Worksheet Functions |