ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Dealing with hidden apostrophes... (https://www.excelbanter.com/excel-discussion-misc-queries/37167-dealing-hidden-apostrophes.html)

MavrikGandalf

Dealing with hidden apostrophes...
 

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.


--
MavrikGandalf
------------------------------------------------------------------------
MavrikGandalf's Profile: http://www.excelforum.com/member.php...o&userid=25620
View this thread: http://www.excelforum.com/showthread...hreadid=390339


modular_brian

Try adding an apostrophe in front of the apostophe. Excel looks to the first
apostophe for formating and the second apostrophe would be text.

"MavrikGandalf" wrote:


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.


--
MavrikGandalf
------------------------------------------------------------------------
MavrikGandalf's Profile: http://www.excelforum.com/member.php...o&userid=25620
View this thread: http://www.excelforum.com/showthread...hreadid=390339




All times are GMT +1. The time now is 05:38 PM.

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