![]() |
#1
|
|||
|
|||
![]()
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??? |
#2
|
|||
|
|||
![]()
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. |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Landscape Orientation - Rotate page so top of landscape is printed on left side | swifty2010 | Word | 17 | 06-11-2022 05:50 PM |
![]() |
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 |