Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default show apostrophe / single quote in cell

Is is possible to have excel show an apostrophe / single quote in cell. I
know you can use it to force text, however, I would like the character to
display in the cell.

Ex. Cell displays Hg and I would like it to display 'Hg'

Thanks,
Chad
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: show apostrophe / single quote in cell

Hi Chad,

Yes, it is possible to display an apostrophe/single quote in a cell in Excel. Here's how you can do it:
  1. Double-click on the cell where you want to display the apostrophe.
  2. Type the apostrophe/single quote character before the text you want to display. For example, type 'Hg instead of Hg.
  3. Press Enter to save the cell.

The apostrophe will now be displayed in the cell along with the text. If you want to display the apostrophe in a formula, you can use the
Formula:
TEXT 
function. Here's an example:
  1. In a cell, type =TEXT("'Hg","General")
  2. Press Enter to save the cell.

The apostrophe will now be displayed in the cell along with the text.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
Red Red is offline
external usenet poster
 
Posts: 48
Default show apostrophe / single quote in cell

Type this ''Hg' (all three are single quotes)

the first one is what forces excel to show the text exactly as you type it,
so the rest will be what is visible.

Thanks
--
Just a fellow Excel user here to help when I can.....


"Beans" wrote:

Is is possible to have excel show an apostrophe / single quote in cell. I
know you can use it to force text, however, I would like the character to
display in the cell.

Ex. Cell displays Hg and I would like it to display 'Hg'

Thanks,
Chad

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default show apostrophe / single quote in cell

start your text with a pair of single quotes and it your text with one single
quote.
--
Gary''s Student - gsnu200767


"Beans" wrote:

Is is possible to have excel show an apostrophe / single quote in cell. I
know you can use it to force text, however, I would like the character to
display in the cell.

Ex. Cell displays Hg and I would like it to display 'Hg'

Thanks,
Chad

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I display a single quote in a cell? Brotha B Excel Discussion (Misc queries) 1 August 17th 07 02:09 AM
Annoying single quote with ever new workbook oldtimer Excel Discussion (Misc queries) 5 February 25th 07 09:05 PM
using a single quote ' in SEARCH function ExTexan Excel Worksheet Functions 2 December 30th 06 01:11 PM
Remove single quote Avadivelan TCS Excel Worksheet Functions 4 October 5th 06 03:48 PM
How can I get rid of the ' single quote sign in excel worksheet Ivan Excel Worksheet Functions 5 October 21st 05 05:35 AM


All times are GMT +1. The time now is 03:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"