Thread: [Solved] Add Standard Prefix To Cells
View Single Post
 
Old 06-14-2013, 04:12 PM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.
Reply With Quote