Thread: Convert to string help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pokdbz pokdbz is offline
external usenet poster
  
Posts: 43
Default 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.
Reply With QuoteReply With Quote