Latest Inquiries - Data Extraction Software

Excel not recognising numbers (doesnt add up)

Submitted: 8/29/2017
Hi there

I have a problem with excel with the data extracted.

Its a row of numbers with some with a negative symbol but it doesnt add up

4
7
9
-4
-2
total

The solution was to replace in excel the numbers using the numpad numbers instead. Seems to be a ascii issue. Is there a way to alter the tables or tell visual web ripper what format it is exactly crawling?

I'm using web crawling mode. (same bug with web browser)

Every time I refresh excel it just thinks its a text field (ive tried number formats in excel etc) nothing works except replacing the numbers using the numpad)

Any suggestions? its a major glitch.

Thanks


Replied: 8/30/2017 8:53:59 AM

Hi,

Please upload your agent file here so we can take a look at it. 

Best regards,