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