Data Shuttle importing Values
When I use Data Shuttle to import data to a sheet, it keeps adding a ' in front of the numbers which turns them into text and not numbers.
For example, $23.50 turns into '23.50 when imported through Data Shuttle.
The original excel file itself is formatted correctly.
Anyone know how to fix this?