1 Replies - 274 Views - Last Post: 14 July 2014 - 07:57 AM Rate Topic: -----

#1 EvanKean  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 09-October 09

VB .Net Pull data from Excel (CSV) File to true numeric value

Posted 14 July 2014 - 06:52 AM

Good Morning All. Here's my delima. When I pull a large numeric value from a CSV file and place it in a textbox, I get the actual cell content, which looks like 1.36215E+17. How can I get this 136215304736470000 instead??
Any help or suggestions will be greatly appreciated.
Evan
Is This A Good Question/Topic? 0
  • +

Replies To: VB .Net Pull data from Excel (CSV) File to true numeric value

#2 Kizzle  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 10
  • Joined: 07-July 14

Re: VB .Net Pull data from Excel (CSV) File to true numeric value

Posted 14 July 2014 - 07:57 AM

Hello Evan,
Have you tried converting the value? for example:
Dim x = Int64.Parse(numericCellValue, Globalization.NumberStyles.Float)
TextBox1.Text = x.ToString



I have not tried this code so there maybe some issues
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1