+ Reply to Thread
Results 1 to 3 of 3

Style 'Percent' not found error

  1. #1
    Registered User
    Join Date
    12-22-2008
    Location
    california
    Posts
    28

    Style 'Percent' not found error

    I'm using MS Excel 2013.

    When I right click to format a row of numbers to % i get the error "Style 'Percent' not found.

    I've googled this problem and some posts say "steal" the default settings from another worksheet by merging using format/styles, etc...

    First, I don't know what their talking about because i don't have those menu options in the first place.

    Secondly, All my sheets are not finding the % available.

    So, I'm not looking for some half-assed superficial fix, I'm looking to FIX the problem.

    Does anyone hear know how to actually fix this problem at the root?

    Thanks,
    bob

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,082

    Re: Style 'Percent' not found error

    Your workbook, the actual spreadsheet itself, is a missing a Percent style.
    You need to merge the style from a workbook that has the missing style.
    I tried to attach a file with the percent style but am having problems.

    Load the problematic workbook.
    Load a workbook that has the percent style
    Go to the problemmatic workbook.
    Click Home
    Click Cell Styles (Just above column M / N)
    Notice near the bottom in Number Format there is no Percent style
    Click Merge Styles
    Select the workbook with the percent style
    Click Cell Styles again
    Near the bottom in Number Format now it says Percent style
    Save your Workbook.
    Now when you click the percent sign you don't get the error.

    Repeat for other workbooks that have the problem.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    12-22-2008
    Location
    california
    Posts
    28

    Re: Style 'Percent' not found error

    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. OR statements against a document type for percent of error
    By EndlessSpreadsheets in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-28-2015, 01:43 PM
  2. [SOLVED] What are the RGB numbers for the colors found in excels style choices?
    By 111StepsAhead in forum Excel General
    Replies: 1
    Last Post: 04-19-2012, 02:06 PM
  3. Replies: 4
    Last Post: 04-15-2009, 01:41 PM
  4. [SOLVED] Getting the message: Style 'currency' not found
    By RJP at NYU in forum Excel General
    Replies: 1
    Last Post: 05-19-2006, 09:35 AM
  5. Replies: 3
    Last Post: 03-16-2006, 08:20 AM
  6. Currency, Percent and Comma Style buttons
    By Leslie Coover in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-08-2006, 09:10 PM
  7. [SOLVED] is there a percent error function in excel?
    By syco1234 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-12-2005, 11:22 AM

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