Data entry

Z

Zeno

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?
 
M

Marcelo

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:
 
K

Ken Hudson

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.
 
G

Gord Dibben

Marcelo

True only if you have Tools>Options>Transition settings checked.


Gord Dibben MS Excel MVP
 
Top