cell format text
 

Hi there,
I code program based on Excel 2000 OLE. I need set number format of cell
(range) to text, but I cannot get the right way from MS reference. Can
anybody guide me how to do that?

Thanks in advance

Jan ©ejnoha

cell format text
 

Hi Jan,

Try something like:

Range("A1:A10").NumberFormat = "@"


---
Regards,
Norman



"Jan ©ejnoha" wrote in message
...
Hi there,
I code program based on Excel 2000 OLE. I need set number format of cell
(range) to text, but I cannot get the right way from MS reference. Can
anybody guide me how to do that?

Thanks in advance

Jan ©ejnoha

cell format text
 

Thanks a lot, it works!

"Norman Jones" pí¹e v diskusním pøíspìvku
...
Hi Jan,

Try something like:

Range("A1:A10").NumberFormat = "@"


---
Regards,
Norman



"Jan ©ejnoha" wrote in message
...
Hi there,
I code program based on Excel 2000 OLE. I need set number format of cell
(range) to text, but I cannot get the right way from MS reference. Can
anybody guide me how to do that?

Thanks in advance

Jan ©ejnoha