Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Chicago, Illinois, USA
    Posts
    187
    Thanks
    6
    Thanked 0 Times in 0 Posts
    How do you put a quotation mark in a custom cell format? I want to indicate inches (") following a number and still be able to use the number in formulas.

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='Zeno' post='799950' date='26-Oct-2009 13:55']How do you put a quotation mark in a custom cell format? I want to indicate inches (") following a number and still be able to use the number in formulas.[/quote]
    There may be a better answer, but I use two single quotes as they appear as a double when using non-monospaced fonts.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Prefix the quote " with a backslash \, this tells Excel to treat the quote as a literal character. For example, to display a number as inches without decimal places:

    0\"

    Or with 1 decimal place:

    0.0\"

  4. #4
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='799953' date='26-Oct-2009 14:16'][/quote]
    Thanks - I never knew that!

Posting Permissions

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