TRUE/FALSE are logical values (-1 and 0 respectively) and Excel always
converts them to dispaly as TRUE/FALSE. To modify the appearance of
TRUE/FALSE enter them as labels by preceeding the entry with an apostrophe:

'True
'False

The apostrophe forces Excel to treat what follows as text and not as a number.

--
Kevin Backmann


" wrote:

I have some string data in CSV formatted spreadsheet.
For example, I fill some cells with lower case strings "true" or
"false"
But after saving the file in CSV format, I see those strings have been
automatically converted to uppercase strings "TRUE" or "FALSE".

I think, there are some configuration in the Excel where this
automatic conversion to uppercase can be avoided. Please let me know.

Thanks.