ExcelBanter - True, how do I get Excel to ignore?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - True, how do I get Excel to ignore? (https://www.excelbanter.com/excel-discussion-misc-queries/119603-true-how-do-i-get-excel-ignore.html)

Veronica

True, how do I get Excel to ignore?

Subject name is True but Excel makes it TRUE and will not sort etc. How do I
get Excel to ignore this. Now I have a space before the name and it keeps it
lowercase but will not sort correctly.
Thanks

Niek Otten

True, how do I get Excel to ignore?

Precede True with an apostrophe. It will not show and sort correctly

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Veronica" wrote in message ...
| Subject name is True but Excel makes it TRUE and will not sort etc. How do I
| get Excel to ignore this. Now I have a space before the name and it keeps it
| lowercase but will not sort correctly.
| Thanks

Allllen

True, how do I get Excel to ignore?

Or you could try
="True"
in your cell.
--
Allllen

"Niek Otten" wrote:

Precede True with an apostrophe. It will not show and sort correctly

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Veronica" wrote in message ...
| Subject name is True but Excel makes it TRUE and will not sort etc. How do I
| get Excel to ignore this. Now I have a space before the name and it keeps it
| lowercase but will not sort correctly.
| Thanks

All times are GMT +1. The time now is 03:48 PM.