Hi All,
I am facing an issue where there is a field in my excel sheet where I want the values to be lower case but excel automatically corrects it to upper case. In case you're wondering, whenever I type "true" or "false" it defaults to "TRUE" and "FALSE". I have tried using the formula "LOWER" to change it and it works temporarily until I save the file, reopen it, and see the fields in upper case again. Additionally, I tried formatting the cell as text and typed everything in lower case but again, it defaults back to upper case upon saving the document. Any idea how to solve this?
With thanks,
Paul
Bookmarks