Forum Discussion
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?
As the IT department, can you format the spreadsheet however you want, push it to your users and instruct them to use it? That way they will use a standardized template and they won't have to do any of the formatting.
Bennadeau We have a template to use for sending spread sheets over the internet via an attachment in an email. The spread sheet is all formatted, including several header records. However, now they want a CSV file, so we can't use the formatted excel sheet we send them. I was thinking maybe adding a =TEST(A1,"000000000000") string to the field....