Skip to main content

Tech Tips - Keep your numbers′ leading zeros in Excel(2000/2002/2003/2004/2007)

Keep your numbers′ leading zeros in Excel(2000/2002/2003/2004/2007)

If you need to enter the Zip code 02364 in your Excel spreadsheet, you′ll probably throw your hands up when Excel automatically changes the value to 2364. Your Zip code must have five digits, but by default Excel doesn′t display leading zeros.

Here′s the solution: Create a custom number format with five digits. This custom format forces Excel to display leading zeros.

To create a custom number format that keeps leading zeros intact:

  1. Select the cell(s) in which you must show leading zeros, such as the column in which you′re storing Zip codes.
  2. Press [Ctrl]1 to open the Format Cells dialog box.
  3. Select Custom from the Category list box.
  4. In the Type text box, enter 00000. This forces Excel to display five digits.
  5. Click OK to apply the change.

Now when you type a number in your newly formatted cells that starts with a zero, Excel preserves the zero instead of automatically hiding it

 

Create a link from Word to Excel

It would be quite convenient if you can click on a link in your Word documen t to go straight to an Excel sheet that you want to open rather than having to start Excel and opening that file.

We′ll show you how to create a clickable hyperlink in Word that links to an Excel file.

  1. Press [Ctrl][F9] with your cursor at the beginning of a sentence where you want to place the link to an Excel file. This will create a couple of curly braces.
  2. Type the following within those curly braces: HYPERLINK "C:\\MyFolderOne\\MiscDocOne.xls". Replace My Folder One and MiscDocOne.xls with the folder names and document names that are relevant to you. Remember to use double back slashes ("\\") while typing your path name.
  3. Press [F9] to create the link based on the field code which you typed.

Now, yo u can click on the link to run Excel and open the specific workbook.

 

 

Thanks & Regards

 

Mohammed Rahman Mecheri

 

System Analyst – Network & Infrastructure
Kamal Osman Jamjoom Group LLC.
Unit #422, Sultan Business Centre
P.O Box 27844, Dubai, UAE
Tel:       +971 (4) 3355232 Extn: 1339
Fax:      +971 (4) 3355231
Mobile:  +971 (50) 9774048
Email:   mohammed.rahman@kojamjoom.com

http://www.kojamjoom.com

 

 

 


DISCLAIMER: This email and any attachments are confidential and may also be privileged. It is intended only for the use of authorized persons. If you are not an addressee, or have received the message in error, you are not authorized to read, copy, disseminate, distribute or use the email or any attachment in any way. Please notify the sender by return email and delete this e-mail   ­­  

Comments

Post a Comment

Please write your comment

Popular posts from this blog

Tech Tips - Turn on Delegate Access

Turn on Delegate Access A delegate automatically receives Send on Behalf permissions. This means your delegate can do the following: ·          Respond to a meeting request sent to you, the manager. ·          Receive meeting request responses sent to you, the manager. ·          Compose and send an e-mail message that, when received, will have Delegate Name   on behalf of   Manager Name   next to   From . By default, the delegate can read only the meeting requests and responses sent to the manager. The delegate does not have access to read any other messages in your   Inbox . 1.      On the   Tools   menu, click   Options . 2.      Click the   Delegates   tab, and then click   Add . If the   Delegates   tab or the   Add   button is mi...
Post a Comment
Read more

How do I choose my password?

How do I choose my password? Your password is more than just a key to your online account. If your password falls into the wrong hands, someone can easily impersonate you while online, sign your name to online service agreements or contracts, engage in transactions, or change your account information. So, choose your password carefully and then keep it safe from others. A password is like a toothbrush: Choose a good one and don't share it. A Yahoo! password can be any length, and can contain spaces, symbols, or numbers. With so many options, you should be able to come up with a password that's easy for you to remember but impossible for someone else to figure out. A password is a secret that only you should know. Here are some tips for choosing a strong password - one that is difficult to guess. . Choose a password you'll remember. It should be memorable for you (so that you don't have to write it down or leave it in the open), but difficult for others to guess....
Post a Comment
Read more

Tech Tip - How to Search Like a Pro

Technology Tip - How to Search Like a Pro The internet is big, really, really big.  And it keeps growing bigger every day.  If you want to search it effectively you’re going to need to develop a couple of tricks to help you narrow the search.  Here’s a few real easy ones to integrate into your next search: Using +, - and “ “ (quotes) to narrow your searches: Lets say you were looking up apples on   Google.com .  If you just type in “apples” you get 22 million returns.  A few more sites than you can check in an afternoon so lets narrow the search down.  Let's say that what you're really interested in is   green apples .  To see all the apple websites that also have the word “green” on them type this: Now you will only see those apple sites that also have the word green on them.  Unfortunately we are still getting almost 6 million returned websites: To narrow the search even more lets elimina...
Post a Comment
Read more