Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 06-08-2013, 08:35 PM
zulhfreelancer's Avatar
zulhfreelancer zulhfreelancer is offline Add Standard Prefix To Cells Mac OS X Add Standard Prefix To Cells Office for Mac 2011
Add Standard Prefix To Cells
Join Date: Dec 2012
Posts: 5
zulhfreelancer is on a distinguished road
Default Add Standard Prefix To Cells

Hi friends,

I'm doing some housekeeping for my friends & family contact numbers. I want to have a standard prefix for them. The prefix that I want is: +60 (Malaysia Country Code telephone number).

In my worksheet now, I have 3 types of data (phone numbers):

First type: 123456789 (no "+60" prefix)
Second type: 0123456789 (no "+6" prefix)
Third type: 60123456789 and +60123456789 (yes, this is what I want)

My question:

How do I check for all First type & Second type data and add the missing "+60" or "+6" prefix for them?


In my country Malaysia, standard telefon number is like this: +60123456789 or 60123456789. This happened to me because before this, I recorded this data using cell phone and I just type '0123456789'. When I transfer the contacts to Excel and sync the contacts via some softwares, they ignore zero '0' in front the telephone number, unless I'm saving the telephone number starting by six '6'.

Thank you for your helps guys!
Reply With Quote
Old 06-14-2013, 04:12 PM
BobBridges's Avatar
BobBridges BobBridges is offline Add Standard Prefix To Cells Windows 7 64bit Add Standard Prefix To Cells Office 2010 32bit
Join Date: May 2013
Location: USA
Posts: 659
BobBridges will become famous soon enoughBobBridges will become famous soon enough

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


Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Prefix "www." to Website Address kjxavier Excel 1 03-05-2012 11:59 PM
Add Standard Prefix To Cells Word 2007 TOC Section Number w/Alpha Prefix? Gwen Butler Office 2 09-29-2011 06:10 AM
Add Standard Prefix To Cells Find & Replace words with "/" prefix & suffix tollanarama Word 4 01-25-2011 02:19 AM
Prefix bug in subject email Outlook 2010, [english: 100%] OfficeBug Office 1 10-25-2010 03:10 PM
Count range cells eliminating merge cells danbenedek Excel 0 06-15-2010 12:40 AM

All times are GMT -7. The time now is 03:33 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd. is not affiliated with Microsoft