Formatting a cell 1

mkjp2011 · Oct 15, 2010

Hello,
How would you change the formatting of a cell from Number to Custom 0?

Also, how would you add borders to the cell?

Here is how I instantiate the excel object:

Set excelReport = CreateObject("Excel.Application")
excelReport.Workbooks.Add
Set excelSheet1 = excelReport.ActiveWorkbook.WorkSheets(1)

SkipVought · Oct 15, 2010

hi,

Code:

 Set excelReport = CreateObject("Excel.Application")
 excelReport.Workbooks.Add
 Set excelSheet1 = excelReport.ActiveWorkbook.WorkSheets(1)  
  excelSheet1.Cells(1,1).NumberFormat = "0"

Skip,
_{Just traded in my old subtlety...

for a NUANCE!}

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Formatting a cell 1

mkjp2011

Programmer

SkipVought

Programmer

Similar threads

Part and Inventory Search

Sponsor