how to put zero
 

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

how to put zero
 

Custom format of
"0"#
will work.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"vishal" wrote:

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

how to put zero
 

Maybe you can use a custom number format.

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



vishal wrote:

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

--

Dave Peterson

how to put zero
 

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???

"vishal" wrote:

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

how to put zero
 

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.
--
David Biddulph

"Roachy" wrote in message
...
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???

"vishal" wrote:

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