+ Reply to Thread
Results 1 to 3 of 3

What does SINGLE QUOTE mean before value in a cell?

  1. #1
    Registered User
    Join Date
    03-16-2005
    Posts
    20

    What does SINGLE QUOTE mean before value in a cell?

    Hello everyone,
    does anybody know what does SINGLE QUOTE mean before value in a cell?
    I have a function VLOOKUP that does NOT work without a SINGLE QUOTE before value in a cell that is searched.
    Surotkin

  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    A single quote (or an apostrophe) is used to signify Text in Excel. A number entered with the leading apostrophe is treated as Text and (generally) cannot be used in calculations. Often used for ZIP codes, phone numbers, Invoice or Product code numbers.

    I would assume your list is actually TEXT and your VLOOKUP will fail if you are trying to look up a number. Hence, the single quote forces it to look for text and then it works.

    HTH

    Bruce
    Bruce
    The older I get, the better I used to be.
    USA

  3. #3
    Registered User
    Join Date
    03-16-2005
    Posts
    20
    Hello Bruce,
    Thank you for the explanation.
    surotkin

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1