If you have text that you want to remain untransformed by Excel then you must save it in the CSV file surrounded by double-quotes e.g. if a file contains
Then the last two columns are explicitly text columns.
If you set the columns to "Text" format then when you save the file it will still be saved as
Note the lack of double-quote characters
Unfortunately if you double-click on the CSV or use File, Open, from within Excel the columns will revert to "General" format and the example above will display as
TRUE TRUE TRUE TRUE TRUE
In order to retain the formatting you need to Import
the data into Excel.
Using the Text Import Wizard, choose comma as the delimiter and when you get to "Step 3 of 3" highlight the appropriate column and click the "Text" RadioButton. Now when you press "Finish" Excel will display
TRUE TRUE TRUE True true
One very important thing to note - in your original spreadsheet
has a value of, well,
...in the either True or False sense. But in your CSV you are forcing the column to be a text value. You can demonstrate this by using the following formula (in Excel) to report on the values (dragging it across from Column A to Column E
=IF(A1=TRUE, "yep", "nope")
You should note that for Columns D and E "nope" is the result. Before you insist on "true" staying as lowercase, consider the impact this will have on any other areas of the worksheet... this is what RyanDev was pointing out to in their point 3.