怎样设置EXCEL的单元格或一列的数据格式为:"文本"?(50分)

C

caoliu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-07-25

• #1

怎样设置EXCEL的单元格或一列的数据格式为:"文本"?
就象在EXCEL操作设置单元格格式.

 

W

wdl

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-07-25

• #2

录制宏,然后查看调用了什么就可以了

 

B

bundur

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-07-25

• #3

Selection.NumberFormatLocal = "@"
或者是
Range['A2'].NumberFormatLocal = "@"

 

L

linsb

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-07-25

• #4

ExcelWorksheet.Cells.Item[Row,Col].NumberFormatLocal := '@';

 

心

心灵琴音

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-07-25

• #5

ExcelWorksheet.Cells.Item[Row,Col].NumberFormatLocal := '@';

呵呵，同三楼

 

C

caoliu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-07-25

• #6

多人接受答案了。