Easy Numeric Question

[jessedh]

I have a long value in excel 20021681010204300 and then I have a cumtom VBA function that pulls the string "81010204300" from this. The problem is that the data is the varying cells is sometimes numeric (as above) and sometimes text. How can I convert the numeric string above into a text version of it? The function only pulls correctly is all of the data is of the text type.

Thanks!
Jesse

 

[acron]

Not being sure of how you function works, but in your example the RIGHT() function can be used as follows, assuming the first 'number' is in A1,

=RIGHT(TEXT(A1,"0&quot,11).

See if you can incorporate the TEXT function in your own formula.

A.C.