Single Quote - Excel 2007
Solved/Closed
smileanandh
Posts
2
Registration date
Tuesday December 8, 2009
Status
Member
Last seen
March 24, 2010
-
Updated on Jan 31, 2019 at 03:39 PM
FLAWLESSVW - Apr 6, 2015 at 06:51 PM
FLAWLESSVW - Apr 6, 2015 at 06:51 PM
Hi,
Does anyone know what the single quotation mark ' means when entered at the beginning of a cell?
I notice that the quotation mark does not actually appear in the cell. In other words, it appears in the formula bar when entered but disappears from the cell once you press enter.
I want to to get rid of that. I need a single quote at the beginning!
Does anyone know what the single quotation mark ' means when entered at the beginning of a cell?
I notice that the quotation mark does not actually appear in the cell. In other words, it appears in the formula bar when entered but disappears from the cell once you press enter.
I want to to get rid of that. I need a single quote at the beginning!
System Configuration: Windows XP / Safari 532.5
Related:
- Single quotation mark in excel
- Excel single quote in formula - Best answers
- Single quotes in excel formula - Best answers
- Mark sheet in excel - Guide
- Insert check mark in word - Guide
- E with accent mark - Guide
- Number to words in excel - Guide
- _ instead of question mark ✓ - Keyboard Forum
6 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Updated on Jan 31, 2019 at 03:40 PM
Updated on Jan 31, 2019 at 03:40 PM
Hi,
That means the value being enter is text. It is like if you want to write 001 in a cell, generally Excel would convert it to 1 but if you write it as '001 it will stay as 001.
That means the value being enter is text. It is like if you want to write 001 in a cell, generally Excel would convert it to 1 but if you write it as '001 it will stay as 001.