ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   punctuation marks won't appear unless character inserted after quo (https://www.excelbanter.com/excel-discussion-misc-queries/150845-punctuation-marks-wont-appear-unless-character-inserted-after-quo.html)

Hollyl

punctuation marks won't appear unless character inserted after quo
 
Hi:
In both Word and Excel, the double-quote and apostrophe won't appear unless
I key another character after or add a space. Can you help? I am using
Office 2002.

jenn

punctuation marks won't appear unless character inserted after quo
 
Hi,

In excel I type ="'" (double quote, aprostrophe, double quote) to make one
apostrophe appear.

Maybe this helps

"Hollyl" wrote:

Hi:
In both Word and Excel, the double-quote and apostrophe won't appear unless
I key another character after or add a space. Can you help? I am using
Office 2002.


Hollyl

punctuation marks won't appear unless character inserted after quo
 
Thanks Jen, but it is the single apostrophe or double quote that won't appear
unless I add a space or another character. I use the apostrophe and
double-quote for the foot and inches symbol, so it is extremely incovenient
to add another keystroke when doing up measurements. I checked in auto
correct and found nothing....

"Hollyl" wrote:

Hi:
In both Word and Excel, the double-quote and apostrophe won't appear unless
I key another character after or add a space. Can you help? I am using
Office 2002.


Bob I

punctuation marks won't appear unless character inserted afterquo
 
Check what keyboard layout you have set in the Operating system.

Control panel, Regional and language options, languages, Details,
Settings, Keyboard.

Hollyl wrote:

Hi:
In both Word and Excel, the double-quote and apostrophe won't appear unless
I key another character after or add a space. Can you help? I am using
Office 2002.



Dave Peterson

punctuation marks won't appear unless character inserted after quo
 
Maybe you have this toggled:
Tools|Options|transition tab|Uncheck Transition navigation keys.

I'd uncheck all those options.

You still will have to type two single apostrophes to see one. Excel uses the
single apostrophe to indicate that the entry should be treated as text.

And with that setting toggled, excel will use Lotus 123 settings:

" means right justify the entry
^ means center the entry
' means left justify the entry

Hollyl wrote:

Hi:
In both Word and Excel, the double-quote and apostrophe won't appear unless
I key another character after or add a space. Can you help? I am using
Office 2002.


--

Dave Peterson

name[_2_]

punctuation marks won't appear unless character inserted after quo
 
Hi, pal!

You have US International set as your input language. In this keyboard
layout there is this bug(?) with punctuation.

Change US International to just US instead.
Enjoy!

Good luck :)


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

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