Data Shuttle importing Values

Michael Culley
Michael Culley ✭✭✭✭✭
edited 11/21/22 in Add Ons and Integrations

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?


Best Answer

  • Julio S.
    Julio S. Moderator
    Answer ✓

    Hi @Michael Culley ,

    I wasn't able to reproduce what you report but I'd like to point that you now can define the data type for each Column value in the "Mapping" section of your Data Shuttle Workflow configuration. I would suggest to define the specific Column as "Number" to try and overcome this:

    If this doesn't seem to work, you could possibly use the VALUE Function in the target sheet to convert those values to the right formatting.

    If none of these suggestions seem to work, I'd suggest opening a ticket with our Support team via this form or accessing the new Customer Support Portal.

    I hope this can be of help.