how to put zero

[vishal]

i want to put zero before any number means 025652 like this

 

[Luke M]

Custom format of
"0"#
will work.

 

[Dave Peterson]

Maybe you can use a custom number format.

Select the range (entire column???)
In xl2003 menus:
Format|Cells|number tab|custom category
000000

 

[Roachy]

Vishal,

Not sure if there is an easier way but I would simply create another column
with "0" in and then concatenate the 0 with you number eg:

CELL A1: 0
CELL A2: 25652
CELL A3: =concatenate(A1,A2) this would return 025652

is this what your looking for???

 

[David Biddulph]

Yes, there is an easier way. If you want to use concatenation, you don't
need to put 0 in A1. You could use =CONCATENATE(0,A2), or just =0&A2.