How do I set Excel cell format to Text format from VB.NET?

N

.Net

Hi There...need help real bad!
I'm looking for a code that I could use to format an excel cell dynamically
when creating a new instance of excel for an card account number field type
with more than 15 digits.
Here is the scenario.
Column name: Card Account
Card account number: xxxxxxxxxxxxxxxx

I cannot format the cells as number so I have to format as text. However,
when I run the process that I have telling to format the column as text (@)
it gives me the result in scientific notation because of the
length, I think.
Here is the VB.NET code:
Select Case sFieldType
Case "Text"
objWorksheet.Range(objWorksheet.Cells(2, i + 1),
objWorksheet.Cells(CStr(mlRecordCount), i + 1)).NumberFormat = "@"

I just need to display the acc. number as is...can someone please help me!
Gladly appreciatted...
Sincerely,
Marlei Taylor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
How do I set Excel cell format to "Text" from VB.NET? 4
How do I set focus (and select text) on a text box on a modeless userform? 0
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Stop XL from changing format? 1
How do I stop Excel 2007 from using scientific notation? 2
Format Text to Number 2
Excel is converting my alphanumeric text to scientific notation 2

Top