Hi,

how can i use the numberformat of cells to convert to a text
i have put in worksheets("x").cells(1,1).numberformat = "Text" but i doesn't
seem to work

appreciate any advise

tks & rdgs