Dealing with hidden apostrophes...

  • Thread starter Thread starter MavrikGandalf
  • Start date Start date
M

MavrikGandalf

Hey guys. I started using Excel yesterday as an easy way to compile a
dictionary for the language Klingon, and it's been going well. My
problem is that Klingon uses the ' (apostrophe) as a letter, and has a
number of words beginning with the apostrophe. When entered into Excel,
however, Excel makes the first apostrophe invisible/chops it off.

My question is such: Is there any way to keep Excel from disappearing
the first apostrophe, or am I stuck doubling up on them just so I can
see them?

Noah

p.s. I don't have the Lotus thing on, I already checked that.
 
Try adding an apostrophe in front of the apostophe. Excel looks to the first
apostophe for formating and the second apostrophe would be text.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Apostrophes and Sorting 3
How can SS#s be displayed as text with all zeros and no dashes? 1
Leading Apostrophe appears in the formula bar but not in the cells 5
Milo-asks: Apostrophe key giving me a-with-an-accent in nonHTML no 1
formatting zip codes 1
"=" in text file formatting messes with my code loop- more elegant (and faster) solution? 5
Remove Formatting Apostrophe 1
can Excel really deal with elapsed time? 1

Back
Top