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

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

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

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

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