Forum Discussion
Formatting CSV numeric values
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....
Flikkery I think you got it, but you need to surround the formula with quotes to escape the comma inside it. Then the CSV file looks like this for the number 1234567890123:
previous column, "=TEXT(1234567890123,0)", subsequent column
ChrisSantosLang i just cannot get the imported CSV to change the numbers to number, even after changing text to coulumns so that i can calculate a column of numbers. i am having to type in each number to that excel recognises a number. i have used formats to change to accounting or even currency and nothing works. this is becoming a very manual process. i am on Windows 10.
zoeMD955 "=TEXT()" is a formula that worked for me. If formulas do not work for you even applied manually in the spreadsheet, then I can understand why they wouldn't help in the CSV (and that seems like a different issue).
