thanks for your reply. i had try to write data with "write_string" subroutine, but the problem is the logic i had made for writing on excel need to change which i have written for "write" subroutine. an itis bit tough for me. because of that i am thinking if there would any way trough which we can initally set all cell should be "Text". if u want i can post that piece of code.