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

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

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

Join for free
Earn from Home, Submit Articles and earn money

Wordpress Plugin For PAP