Data format conversion to export from a .csv file to excel

Welcome to the forum.

The best tool to deal with this impor issues is Power Query (native Excel tool), it can import and take care of the decimal, but to help you further we need some file.

Thank you for your reply!

The file would be the following:

MC2.csv

(im sorry if the file doesnt upload correctly, its my first time)

And once I'm in the Power Query, where should I go to change the format? I can`t find the option.

It seems like Excel is interpreting the values incorrectly due to the decimal separator. You can try the following steps to resolve the issue:

Change Decimal Separator: Ensure that Excel is configured to use the correct decimal separator. You can do this by going to Control Panel > Clock and Region > Region > Additional settings, and then changing the Decimal symbol to "." (dot).

Format Cells: After importing the data, select the column containing the resistor values, right-click, and choose Format Cells. In the Number tab, select Number or Decimal, and set the appropriate number of decimal places.

Text to Columns: If the values are still not displayed correctly, try using the Text to Columns feature. Select the column with the resistor values, go to the Data tab, and click Text to Columns. Choose Delimited, click Next, uncheck all delimiters, click Next again, and then choose General or Number format.

Custom Format: If none of the above methods work, you can use a custom format. Select the column with the resistor values, right-click, and choose Format Cells. In the Number tab, select Custom, and then enter "0.000000" as the format code. This will force Excel to display the values with six decimal places.

By following these steps, you should be able to display the resistor values correctly in Excel. If you continue to encounter issues, feel free to ask for further assistance!

Okay, I solved it. Thank you! It was indeed a format problem

Have you tried just importing the csv via the Data tab? Seems to work for me.

With Power Query I managed to import the file as text, but once inside of PQ you can any transformation.

Formula:

let

    Fonte = Csv.Document(File.Contents("D:\Users\DomingosJunqueira\Downloads\MC2.csv"),15,"",ExtraValues.Ignore,65001),

    #"Alterar Tipo" = Table.TransformColumnTypes(Fonte,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}, {"Column11", type text}, {"Column12", type text}, {"Column13", type text}, {"Column14", type text}, {"Column15", type text}}),

    #"Colunas Removidas" = Table.RemoveColumns(#"Alterar Tipo",{"Column15"}),

    #"Cabeçalhos Promovidos" = Table.PromoteHeaders(#"Colunas Removidas", [PromoteAllScalars=true])

in

    #"Cabeçalhos Promovidos"