| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How to Insert function right on text values e.g. 0180001640
Is your cell formatted for Text? If so, Change to General, hit ENTER then F2
then ENTER. HTH, -- Gary Brown "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 | |||
Hybrid Mode
