This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I need some help. I have to submit a CSV file to a program and it can only be a CSV file. The issue i have is i have a column of numbers that contain an e in the middle of it so the CSV file automatically converts it to scientific notation. i have downloaded the power query add in and this doesnt seem to help when i follow the directions. Can anyone help me figure out how to convert the numbers back to numbers and not in scientific notation. I already tried converting it to text and using formulas and anything else. Please help
Thank you
Mike
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Enclose the text in double quotes and place an equal sign in front of it like the following and then save as csv.
="0503E000"