How To Format Phone Numbers In Excel

Earlier today, I decided to send a bulk sms to over 5000 phone numbers at NairaForSMS. The numbers were in an excel file but not in the format supported by the bulk sms site. After copying the numbers from the excel sheet to a notepad, the numbers were displayed in the form of 2.34704E+12 instead of 2347000000000.





Without using any file conversion software, I was able to format the phone numbers in excel without decimals i.e I was able to make the numbers display as phone numbers.

If you've got some phone numbers you would like to format in similar way, just follow me through the steps below:



==> Select range of cells containing the phone numbers

==> Right Click on the selection

==> Click format cells option

==> Click the "Numbers" tab

==> Click "Custom" in the category list

==> Click "O" as the type as seen in the screenshot below:

==> Click OK.



The numbers in the selected range of cells should now display the phone numbers completely.



Recommended:  How To Add First Zero to Nigerian Phone Numbers At Once With Excel

Read More

Create Invoices Online With Free Templates at Office.live.com

An invoice is a document issued by a seller to a buyer for products sold or services rendered indicating the products or services, the agreed prices and other necessary info related to the transaction. There are softwares you can use to create invoices. There are also invoice templates you can download and edit with Microsoft office program.





You can find yourself in situations when you might not have access to a PC or the invoice templates you downloaded are not compatible with the version of Microsoft office installed on your PC. In such cases, if you have access to the internet, you can create professional invoices online with free templates at office.live.com. All you just need is an active free outlook account.



To get started, log on to office.live.com



Click on the "Excel Online" tab, then click on "Browse Templates"



Under the categories, click on "Invoices". You will see the available free invoice samples you can edit.

Click on the one you like, then on the new page that opens, click on "Open in Excel Online".



You can then customize it the way you want. As you are working on it, the changes save automatically and sync across all your devices where you might have installed the Microsoft Onedrive app.



Once you are through, you can click on "File" > "Save As..." > "Download a Copy" to save a copy to your computer after which you can send it as an email attachment to the recipient.



You can always access the invoice online at office.live.com and also via the Onedrive app installed on your PC and mobile devices.



That's all.



I hope this helps.

Read More

How To Copy WorkSheet From Excel Workbook File To Another

Sometimes, you might have an Excel worksheet you wish to include as a worksheet in another Excel file i.e workbook. You can get this done with ease using an Excel built-in feature instead of using "copy and paste". Using "copy and Paste" can frustrate you and might even make you lose some formatting styles.



The trick am sharing with you in this tutorial will let you insert worksheets from other workbooks quickly without losing data and formatting styles. It simply involves the use of the "Move or Copy" command in the same instance of Excel.

As an example, I'm going to show you how I copied a worksheet in Excel 2003 from a "source" workbook i.e sales.xls to a "target" workbook i.e jideexcel.xls. Just follow me through the steps:



1. Open the workbooks you want to work with (source and the target workbook)
2. In the source workbook, click on the tab of the sheet you want to copy
3. Right click the selected worksheet, and click Move or Copy

4. In Move or Copy dialog box, click the "create a copy" option and choose the target workbook from the "To book" dropdown. Excel will display only the open workbooks in this list.

5. Click OK and Excel will move or copy the sheet to the target workbook.

That's all.

I hope it works for you.

You can get a free Beginners guide to working with spreadsheets in excel and DIAGRAMMATIC presentations on how to use Excel from my 20 Free Ebooks here.

Read More