Convert to string help

  • Thread starter Thread starter pokdbz
  • Start date Start date
P

pokdbz

I'm using this statement:
ActiveCell.Offset(0, j + 2) = SAPReportSummaryArray(i, j)

SAPReportSummaryArray(i, j) = "7-11"
When I watch it stepping through its showing 7/11/2008. I need help forcing
this to text any ideas so it would show 7-11? ActiveCell.Offset(0, j + 2) is
the cell I want to insert it into.
 
In the most simple case:

Sub pok()
Range("A1").Value = "7-11"
End Sub

will put a date in the cell

Sub pok()
Range("A1").NumberFormat = "@"
Range("A1").Value = "7-11"
End Sub

will put the desired text in the cell.
 
Back
Top