Hi Patrick

Thanks for giving me the formula to add 99 before the digit its working
perfectly but i could not make use of the code which you hav esuggested,
i have inserted the code by right clicking the sheet1- viewcode and
pasted the code but i could not able to run the macro.

So please help as im new to excel.

The code is:

dim cell as range
dim text as string
set cell = range("A1")
do until isempty(cell)
text = cell.value
cell.value = LEFT("990000000000",12 - len(text) ) & text
set cell = cell.offset(1)
loop


--
Raja
------------------------------------------------------------------------
Raja's Profile: http://www.thecodecage.com/forumz/member.php?userid=497
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115089