Forum Discussion
Flikkery
Jun 19, 2020Copper Contributor
Formatting CSV numeric values
I created a CSV file with a twelve numeric value id (as in a Medicaid Id). The Excel sheet converts this 12 digit number into a 1E+11 format. Is there a way to prevent this?
Bennadeau
Jun 19, 2020Iron Contributor
Not sure if this will work for you but either you pre-pend the number with a single quote when you create the CSV which will format the cell as text or open that CSV using Notepad/Wordpad.
I get that this may not be the solution you're looking for but I hope it may lead you in the direction of your solution.
Flikkery
Jun 19, 2020Copper Contributor
Bennadeau Yes, by making the numeric value as an alphanumeric value with the addition of any none numeric value, like a single quote, within the value impedes Excel from the SCI formatting. This doesn't circumvent the need for the user to manipulate the data, since they will need to REPLACE the quote with nulls.