Export in csv

[Giada90]

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

[Sahir_Maharaj · Accepted solution]

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.

[Giada90]

thanks