View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
huskybytes huskybytes is offline
external usenet poster
 
Posts: 2
Default How to format text 'exactly' as entered.

Text entered into a cell is automatically formatted to Uppercase 'first
letter'. If I choose:format I am provided with choices of UPPER or LOWER or
PROPER but I want to enter the phrase 'eFile' or 'eOPF' exactly as I type it.
Only thing that works is enclosing the letters in parenthesis. I thought
preceeding by an apostrophe would string it but that did not work.