Hasn't anyone answered this yet, zuhl? Sheesh, I apologize; I've been away a few days but I didn't expect that. What you want here is to convert the number to text, then probably check to see whether the first two bytes are "60" or the first three are "+60". If they are not, you add the "+60"; then, whether you had to change it or not, convert back to numerics.
I'd give specific examples, but looking again it seems that your entries are a mix of numeric and text, and it isn't clear to me whether you want numeric or text results. Maybe it doesn't matter; maybe by now it's obvious to you what you want to do. But if not, confirm that the current values are a mix and tell me whether you want text or numeric results and we'll go into specifics.
|