Results 1 to 4 of 4

Return a percentage in a cell, Not a decimal value

This is a discussion on Return a percentage in a cell, Not a decimal value within the Excel Questions forums, part of the Question Forums category; How do I return a percentage value in a cell. I am using Excel 2000. I need to divide the ...

  1. #1
    New Member
    Join Date
    Oct 2003
    Posts
    2

    Default Return a percentage in a cell, Not a decimal value

    How do I return a percentage value in a cell. I am using Excel 2000. I need to divide the value of two cell and return the percentage with a label before it.

    I enter the formula ="Margin " &(A15/C45)

    I want the return to look like this: Margin 52%

    But, I keep getting this: Margin .52458457856

    What is wrong with my formula. Also tried to format cell for percentage, That didn't work ether.

    Thank You in advance for any help

  2. #2
    DRJ
    DRJ is offline
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,856

    Default Re: Return a percentage in a cell, Not a decimal value

    Try something like this

    Assuming value you want is in range("B2")

    MsgBox "Margin: " & Format(Range("B2").Value, "Percent")

  3. #3
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Crested Butte, CO
    Posts
    27,134

    Default Re: Return a percentage in a cell, Not a decimal value

    Welcome to the Board!

    Try this:

    ="Margin "&TEXT(A15/C45,"0.00%")

    Hope that helps,

    Smitty

  4. #4
    New Member
    Join Date
    Oct 2003
    Posts
    2

    Default Re: Return a percentage in a cell, Not a decimal value

    Thank you for all your replys, Penny the formula work great!

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
  •  


DMCA.com