worksheets("x").cells(1,1).numberformat = "@"

--
HTH

Bob Phillips

"maxzsim" wrote in message
...
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