Skip to main content

    Issues

    Completed

    Exporting .csv - problem with currency and date formats

    Vote (1) Share
    ryan's profile image

    ryan on 21 May 2016 01:28:25

    There is a problem I have found when exporting currency formatted columns from PBI to .csv
    Once you open this .csv in excel, the dollar sign gets put adjacent to the number value, as a result, excel doesnt recognize that A. this is a number and B. that it is currency - so even if you try to reformat the column in excel, its impossible... the only workaround I have found is to forgo formating like currency in PBI

    Comments (2)
    ryan's profile image Profile Picture

    sadf sdf on 05 Jul 2020 22:23:22

    RE: Exporting .csv - problem with currency and date formats

    Hello Ryan,
    Wanted to let you know the team is working one something that will also make this much better going forward.
    Thanks
    Chuck

    ryan's profile image Profile Picture

    sadf sdf on 05 Jul 2020 22:23:19

    RE: Exporting .csv - problem with currency and date formats

    Hello Ryan,
    I will ask the team but the current export is by design and easy to resolve in Excel.
    To fix these values back to numbers in Excel type a 1 in a cell, copy it, and highlight the columns with these $ strings. Right click and choose paste special > multiply.
    Thanks,
    Chuck