Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-28-2010, 10:01 AM
nmo111 nmo111 is offline Import contact from EXCEL to Outlook (no zero in left side digit) Windows Vista Import contact from EXCEL to Outlook (no zero in left side digit) Office 2007
Novice
Import contact from EXCEL to Outlook (no zero in left side digit)
 
Join Date: May 2010
Posts: 1
nmo111 is on a distinguished road
Exclamation Import contact from EXCEL to Outlook (no zero in left side digit)

Hi,

Imported 500 numbers fax contacts list of from excel to outlook 2007.
We plan to execute fax broadcast thru winfax pro 10.02


Problem is zero can't be added in left side in excel cell.
to run the fax broadcast automatically we must add zero then dial remaining digits.
how can fix this problem without going manually thru all numbers???
Reply With Quote
  #2  
Old 05-28-2010, 11:00 AM
Kimberly Kimberly is offline Import contact from EXCEL to Outlook (no zero in left side digit) Windows 7 Import contact from EXCEL to Outlook (no zero in left side digit) Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

I can't tell from your post where the data originated from, or where it is now.
There are 2 different answers depending on what you're doing... if you are about to enter data into cell, first format the column as Text, and then it will allow you to enter numeric characters and start with 0.
But I suspect you have the fax numbers in Excel, but need to have a zero in from of each one.
If the first fax number is in cell A1, put this in B1:
=0&A1
Copy down.
Now to convert the formula: Select all the formulas and Copy
Use the Paste drop-down and choose Paste Values.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Landscape Orientation - Rotate page so top of landscape is printed on left side swifty2010 Word 16 10-11-2015 11:01 AM
Import contact from EXCEL to Outlook (no zero in left side digit) How to import .contact files into outlook 2007 eekie Outlook 1 07-02-2010 05:40 AM
Scroll Bar appearing left side aligahk06 Word 2 10-20-2009 04:30 AM
Contact import glitch cwaman Outlook 0 07-02-2009 11:12 AM
line up data side by side jd Excel 0 03-19-2006 01:28 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:44 PM.


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