Forum Discussion

Giada90's avatar
Giada90
Helper IV
2 years ago
Solved

Export in csv

Hi,

I need to export a column in text format.

The column is something like this:

A,B ,C ,4.1, 4.2

 

If I export is CSV with power bi desktop and I open the CSV in excel type I have this format

A, B, C, 41, 42  

In particular, 4.1 of csv become 41 in excel, how can I do?

Thanks

Need Help
  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    2 years ago

    Hello Giada90,

     

    Can you please try this:

     

    1. Transform the Column to Text

    FormattedColumn = FORMAT('YourTableName'[YourColumnName], "0.0")

    2. Add a Prefix to Force Text Interpretation in Excel

    ExportColumn = "'" & FORMAT('YourTableName'[YourColumnName], "0.0")

    Hope this helps.

2 Replies

  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    Super User
    2 years ago

    Hello Giada90,

     

    Can you please try this:

     

    1. Transform the Column to Text

    FormattedColumn = FORMAT('YourTableName'[YourColumnName], "0.0")

    2. Add a Prefix to Force Text Interpretation in Excel

    ExportColumn = "'" & FORMAT('YourTableName'[YourColumnName], "0.0")

    Hope this helps.