Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
IXL@XL
Lv 7
IXL@XL asked in Computers & InternetProgramming & Design · 1 decade ago

Excel and Quotation marks in custom formats?

Anyone out there know how to include quotation marks into custom formats so that the format displays the quotation marks? I usually use 2 apostrophes enclosed within quotation marks as a substitute but was wondering if there was a method to use actual quotation marks.

3 Answers

Relevance
  • peteams
    Lv 7
    1 decade ago
    Favorite Answer

    Put a backslash in front of the character, so \"000.00\" will format 42 as "042.00"

  • nedeau
    Lv 4
    5 years ago

    Excel Custom Format

    Source(s): https://shorte.im/a0IEK
  • ?
    5 years ago

    It's just showing you how your numbers will look, i.e. with commas, decimal points etc. Instead of giving you actual numbers, it gives the hash mark.

Still have questions? Get your answers by asking now.