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.