sorry guys my mistake for the previous mail. The 'excel' generation is actually in .csv format. In other words, I use Open xxxxx ..(where xxx is .csv format) then using a string, i pass the string into the file row by row through a loop. This is not the normal excel application whereby i can use the .numberformat ...if thats the case how do i perform the insertion of zero number in front?