Forum Discussion
Formatting CSV numeric values
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).
