My CSV file contains phone numbers in the scientific format, eg.
441642318911 appears as 4.42E+11
Within Excel I can see the correct phone number but everything I have tried in QV gives me a value of 441000000000.
I haven't been able to find a solution on this forum - any ideas?
Thank you! It resolved my problem with this number 1120180701030000, it was loaded as 1,12018070103e+15. I applied the num function with '(dec)' and it returned the correct number 1120180701030000