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

Multiple Choice Love Letter - Q&A Type Reply (Hilarious)

A teenage college guy sent a love letter (in Q/A format) to his classmate.   My Dearest Ishaa,     Please answer the following questionnaire. For Options   (A) 10 marks, (b) 5marks and (c) 3 marks.   **********   1) Whenever you enter the class room, your sight always falls on me because:   (a) of love (b) you couldn't control seeing me (c) really ... Am I doing it?   **********   2) Whenever professor cracks joke, you laugh and turn and look at me because:   (a) you always like to see me smiling (b) you are testing whether I like jokes (c) you are attracted by my smile   **********   3) When you were singing in the class, I entered and immediately you stopped singing because:   (a) you are so coy to sing before me (b) my presence influenced you (c) you feared that whether I'll like your song   **********   4) When you were showing your childhood photo, when I asked for it, you hide it because:   (a) you fel...
Post a Comment
Read more

Healthy Heart - Tips

(Attchd): Heart Attack + Natural Home therapy for opening the veins of the heart. For Heart Vein opening: Lemon juice              01 cup Ginger juice              01 cup Garlic  juice              01 cup Apple vinegar            01 cup Mix all above and boil on low heat, approximately half  hour, when it becomes 3 cups, take off stove and let cool. After cooling, mix 3 cups of natural honey and keep it in bottle. Every morning before breakfast  use one Table spoon regularly. Your blockage of Vein's will open. No need now for any Angiography  or Bypass... Please pass on this to your real well wishers... Wishing you a healthy life     Thanks & Regards ============================ Mohammed Rahman Mecheri ...
1 comment
Read more