Entering a number with zero in the beginning in an Excel Sheet

I am sure some of you have faced this problem of entering a number like “023423423” in an excel sheet and it will automatically change to “23423423”. The zero goes of automatically. What to be done? In fact the cell takes this as number and removes the zero prefix. So you need to tell the cell that its not number but a text.

First you need to edit the cell properties, but pressing the ctrl + 1 key and in the number tab, select text

image

Click ok and you will find that the number is the same that you have typed

Bookmark and Share

This post was written by:

Kishore Asokan.
About Kishore - I have been working on different online projects for some time now. Making money online is my biggest challenge and to some extend I have succeeded. Visit Kishore Asokan's website to find out more.. Read other articles writtern by Asokan Kishore

Kishore On Digg | Kishore On Twitter | Kishore On Facebook | Kishore On Stumbleupon

Wordpress Plugin For PAP

Related Posts

  • Wordpress Plugin to manage affiliate links
  • I just installed MaxBlogPress which is an...
  • Email Client for iPhone – ibisMail
  • [media id=31 width=585 height=360] ibisMail is a new email...
  • Get my Money Making E-Book For Free
  • I have been doing good number of...
  • Trivandrum International Airport
  • I have be using Trivandrum International Airport for...
  • What is Technorati Authority
  • I have been seeing this Authority icon on...

    Leave a Reply

    Free Home Jobs

    Affiliate Panel Login | New Members Sign-up

    Login to this Blog


    My Flickr Photos - See all photos