Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
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
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
 

Tags
prefix



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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:32 PM.


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