ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data entry (https://www.excelbanter.com/excel-discussion-misc-queries/111694-data-entry.html)

Zeno

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?

Marcelo

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?


Ken Hudson

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?


Gord Dibben

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




All times are GMT +1. The time now is 05:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com