View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Bill Sharpe Bill Sharpe is offline
external usenet poster
 
Posts: 348
Default Format to lowercase

David Biddulph wrote:
Fine as far as it goes, but remember that in such situations a
case-sensitive comparison with the lower case alternative would presumably
not succeed. You are presumably just seeing the upper case letters
*displayed* the same as lower case.
--
David Biddulph

True enough, but the OP only asked about displaying the information, not
making comparisons. My own approach would be to make sure that entries
are made using a mix of upper and lower case as needed, but that's not
what was asked.

Bill