Cannot change format of scientific value on Microsoft Excel Comma Separated Values File

[saudi_red_neck]

Hello friends, Hope all is well!

Please check out the attachment here. Trying to change the formatting of the column before the last (ID).

it is scientific, I need it to be number and without decimals.
Every time make the change, and save, then reopen the changes do not take place.

Thank you very much in advance

[JohnTopley]

Save as XLSX file after reformatting the ID to NUMBER..

[saudi_red_neck]

thank you, I did, fixed the format to number, saved, closed, opened, and saved again as CSV comma delimited, and still formatting of ID is in scientific.
Please help

[JohnTopley]

Use the XLSX file - why not ?

[saudi_red_neck]

need to use CSV in order to use it as Database for powerquery.

[oeldere]

need to use CSV in order to use it as Database for powerquery.

You can also use Power Query from xlsx files.

[TMS]

It's probably just Excel displaying it as scientific. Open the file In NotePad and see what it looks like.

[MrShorty]

As TMS notes, I open the file in a text editor, and I don't see any field with numbers in scientific format. I see "ID" field (third field) that has 15 digit integers (at the limit of what double precision can store), but nothing in the text file that is in scientific format.

Remember that text files (and csv files are just text files) do not contain any formatting information, so part of understanding the problem is understanding exactly when the numbers get converted to "scientific format" and understanding exactly what is happening at that point. I suspect that you are opening the csv file in Excel (using the File->open command or equivalent). Excel tries to be smart about how it imports and displays fields. In this case, I suspect that it sees the very large 15 digit ID number and decides to display as scientific with fewer digits (even though all 15 digits are probably still present in the field). If you don't like Excel's default scientific format for very large numbers, you will probably need to format the field/column as integer or something in order to display the numbers in a way that you would prefer.

If you are going to be using Power Query to process the file, then it may not even matter what Excel does during file opening. As long as no information is actually lost, let Power Query handle those very large numbers in a way that is useful for the analysis or data shaping that you are trying to do.

In short, I don't see anything wrong with the data in the text file. If there are problems (I don't foresee any), they will occur while opening/importing the file into Excel. We would need to understand exactly how you are opening the file into Excel, exactly what the problem is, and how Excel's errors (if any) are going to impact Power Query's tasks.

[TMS]

Thanks for the rep.