how to enter number like 00918814 in excel sheet

S

subu

Hi every one i want to save my excel sheet cell line as a typed (00918818).
when i enter 00 before any number when i enter 00 dispering pls help me
 
D

Daniel.C

Hi.
Use text format for your cells or enter a single quote before your
numbers.
Regards.
Daniel
 
D

David Biddulph

.... or format as 00000000 (but in this case remember that although the
leading zeroes are displayed, the number stored is still without leading
zeroes), or use the formula =TEXT(A2,"00000000")
 
Top