ReadExcel returns a 16 digit number in scientific notation

Getting started -basics for starting with WinTask

ReadExcel returns a 16 digit number in scientific notation

Postby Betty on Mon Apr 07, 2014 9:55 am

I am trying your 30 days version,now.
When I am copying 16 digit number from excel,instead of directly writing same number to form,my script is writing it in scientific notation.
Can you please tell me solution for this
Betty
 
Posts: 22
Joined: Thu May 12, 2005 11:21 am

Re: ReadExcel returns a 16 digit number in scientific notation

Postby TechSupport on Tue Apr 08, 2014 8:17 am

Hello,

You need for format the cells where your 16 digit numbers are as Text cells, then ReadExcel will populate the array with the 16 digits instead of the scientific notation.

Regards.
WinTask Tech Support
TechSupport
 
Posts: 805
Joined: Thu Nov 16, 2006 9:58 am


Return to Getting started

Who is online

Users browsing this forum: No registered users and 2 guests

cron