Excel not recognising numbers (doesnt add up)
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
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.