| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to Insert function right on text values e.g. 0180001640
The new field on the spreadsheet reflects the inserted formula and not the
resulting value. During the insert process however, the expected output appears properly in the Function Arguments window. |
|
#2
|
|||
|
|||
|
Make sure the cell that holds the formula is not formatted as text, you can
try this, select the cell, format as general, press F2 and enter Regards, Peo Sjoblom "Norm Genest" wrote: The new field on the spreadsheet reflects the inserted formula and not the resulting value. During the insert process however, the expected output appears properly in the Function Arguments window. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert characters in a text string | Excel Worksheet Functions | |||
| UDF and Calculation tree | Links and Linking in Excel | |||
| How do I insert a row when using an if function | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| Variable values in Index function | Excel Worksheet Functions | |||
Linear Mode
