Oct 17 2021 09:06 PM
Hi all,
I am working on this file inserting data into .csv file.
Tha data include several sets of numbers separated by commas (eg. 24126,341255,512581, and so on)
Whenever I insert them into a cell, save the file, close it and reopen, the data in the cell displays as ######## and when I look closely at the cell, all the values turn into a gibberish number like 1.25530629077714E+115.
I discovered that the only way to solve this is to add a space in front of the value and after each comma ( 24126, 341255, 512581)
This method is very impractical. Is there any other way to stop excel from automatically formatting values I put in the cell? If yes, this would help me save a lot of time in my workflow.
Thank you!
Pjuvish
Oct 17 2021 09:58 PM
@pjuvish Excel merely "thinks" you are inserting a very large number, and converts it to scientific notation (i.e. the number with E+ in it). To avoid this, format the column/range where you want to input the strings with numbers and commas as Text, before you enter these strings.
Oct 17 2021 10:02 PM
Oct 17 2021 10:15 PM
@pjuvish Can you upload your file?
Oct 17 2021 11:28 PM