Hi,
Suppose your number is in cell A1 in B1 enter

="0"&A1

copy the formula down

if this helps click yes, thanks

"vishal" wrote:

i want to put zero (0) before any given number like038388