Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data entry
When my boss tries to type a quotation mark, it does not appear nor does the
cursor advance until you press the spacebar. How can I correct this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data entry
Hi Zeno,
excel understanding the quotation " as a code to line the text to the right side of the cell, as ' to the left and ^to center you can type "" (twice) or '" hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Zeno" escreveu: When my boss tries to type a quotation mark, it does not appear nor does the cursor advance until you press the spacebar. How can I correct this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data entry
Hi,
A leading single quote is invisible. It tells Excel to treat the following characters as text. If you want to see a single quote, enter two single quotes. -- Ken Hudson "Zeno" wrote: When my boss tries to type a quotation mark, it does not appear nor does the cursor advance until you press the spacebar. How can I correct this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data entry
Marcelo
True only if you have ToolsOptionsTransition settings checked. Gord Dibben MS Excel MVP On Tue, 26 Sep 2006 15:35:02 -0700, Marcelo wrote: Hi Zeno, excel understanding the quotation " as a code to line the text to the right side of the cell, as ' to the left and ^to center you can type "" (twice) or '" hth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
prevent data entry into cell? | Excel Worksheet Functions | |||
Data Entry Using Pulldown | Excel Worksheet Functions | |||
Simplified Data Entry | Excel Discussion (Misc queries) | |||
Data entry using pull down | Excel Discussion (Misc queries) | |||
data entry form Excel | Excel Discussion (Misc queries) |