troubleshooting Question

How to add " ' " when transferring DataGrid data to Excel?

Avatar of chkueh
chkuehFlag for Singapore asked on
Visual Basic.NETMicrosoft ExcelMicrosoft Development
2 Comments1 Solution154 ViewsLast Modified:
Hi, Experts,
I would like to add " ' " in the excel cell to avoid zero missing for number format, for example (000123). I want whole number to be displayed in the  excel cell, without " ' " in excel the number will become (123) only.
Previously, i add Section A code to add " ' "  to get whole number displayed, but now is i cannot add " ' " for code in Section B.
Can any one tell me how to add " ' " before dr("No") ?

Thank you.
Best Regards,
Section A:
Dim No As String = Trim(txtNo.Text)
excelWorksheet.Range("C4").Value = "'" & No 
Section B:
.Range("B" & i.ToString).Value = dr("No")
.Range("B" & i.ToString).HorizontalAlignment = Excel.Constants.xlLeft
Planning & Analytics Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros