Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format text 'exactly' as entered.
Go to Tools-AutoCorrect Options. Either deselect one of the checkboxes, or
make sure you have accidentally created a rule that changes "eFile" automatically to "Efile", or something similar. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "huskybytes" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format text 'exactly' as entered.
Where on the Excel 2007 ribbon is 'Tools'?
"Luke M" wrote: Go to Tools-AutoCorrect Options. Either deselect one of the checkboxes, or make sure you have accidentally created a rule that changes "eFile" automatically to "Efile", or something similar. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "huskybytes" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format text 'exactly' as entered.
If you can't find your way from Excel 2003 commands to Excel 2007
equivalents, try: http://office.microsoft.com/en-us/ex...491511033.aspx or http://www.rondebruin.nl/0307commands.htm or http://www.computerworld.com/action/...leId=9028 218 -- David Biddulph "huskybytes" wrote in message ... Where on the Excel 2007 ribbon is 'Tools'? "Luke M" wrote: Go to Tools-AutoCorrect Options. Either deselect one of the checkboxes, or make sure you have accidentally created a rule that changes "eFile" automatically to "Efile", or something similar. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "huskybytes" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Max values entered and format | Excel Discussion (Misc queries) | |||
%s in XL entered as ".5" OR "50" reads as 50% if format is %age. | Excel Discussion (Misc queries) | |||
Formatted Cell Changes Format When Text Is Entered | Setting up and Configuration of Excel | |||
Text shown up in other cells everytime a text is entered in 1 cell | Excel Discussion (Misc queries) | |||
How to format numbers that are already entered? | Excel Worksheet Functions |