Hi, that doesn't seem to work, should it convert numbers to text? TY Hi , Basically what this does is change the cell format to TEXT. Can you upload your workbook , and indicate where this does not work ? Narayan