Convert to string help
 

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.

Convert to string help
 

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.
--
Gary''s Student - gsnu200791


"pokdbz" wrote:


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.