Results 1 to 8 of 8

Thread: Convert Percent to Basis Points Format

  1. #1
    Board Regular
    Join Date
    Nov 2004
    Posts
    118
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Convert Percent to Basis Points Format

    Does anyone know if there is a customer format I can use to change the percent value of a cell to basis points? I tried creating my own, but was having difficulty. For example, if the cell value in A1 is 2%, I would like to have it say 200 basis points instead.

    Thanks.

  2. #2
    MrExcel MVP
    Moderator
    Inactive
    Richard Schollar's Avatar
    Join Date
    Apr 2005
    Location
    UK
    Posts
    23,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default

    I do not believe there is (would love to be proved wrong, however) - the closest I could get to it was to use a format like:

    0%%

    If you use this and input 0.02 then it displays as:

    200%%

    which isn't really ideal.
    Richard Schollar

    Using xl2013

  3. #3
    New Member
    Join Date
    Jun 2014
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Convert Percent to Basis Points Format

    atgordon,

    Did you try to change your formula to multiply by 10000 and then format as a number? That's our workaround!

  4. #4
    Board Regular
    Join Date
    Jan 2007
    Posts
    1,192
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Convert Percent to Basis Points Format


  5. #5
    New Member
    Join Date
    Feb 2017
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Convert Percent to Basis Points Format

    multiply the % by 10000 and right click, format cell, under Numbers Tab click on custom and add the code below code under Type:

    0 "bps";(0 "bps");-

  6. #6
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,332
    Post Thanks / Like
    Mentioned
    17 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Convert Percent to Basis Points Format

    @arjunambiar
    I think you're a bit late on this one.....the thread was started 10 years ago !!!
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  7. #7
    New Member
    Join Date
    Jun 2017
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up Re: Convert Percent to Basis Points Format

    Quote Originally Posted by arjunambiar View Post
    multiply the % by 10000 and right click, format cell, under Numbers Tab click on custom and add the code below code under Type:

    0 "bps";(0 "bps");-

    Arjunambiar, This worked great! Thank you for the custom format info

  8. #8
    New Member
    Join Date
    Dec 2017
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Convert Percent to Basis Points Format

    This worked perfectly!! Thank you!!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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