+ Reply to Thread
Results 1 to 5 of 5

convert a percentage cell to a normal number in another cell

  1. #1
    Forum Contributor
    Join Date
    03-20-2013
    Location
    London, England
    MS-Off Ver
    Excel 2011
    Posts
    474

    convert a percentage cell to a normal number in another cell

    hello,

    in cell A1 i have a percentage number based on dividing two other cells.
    lets say it says 80%.
    is it possible for cell B1 to be a 'general' value and copy the A1 percentage.
    so just display 80.

    thanks

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: convert a percentage cell to a normal number in another cell

    You could try =A1*100
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    03-20-2013
    Location
    London, England
    MS-Off Ver
    Excel 2011
    Posts
    474

    Re: convert a percentage cell to a normal number in another cell

    of course.
    thanks man

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: convert a percentage cell to a normal number in another cell

    You could use: =A1 and format as a NUMBER or GENERAL.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: convert a percentage cell to a normal number in another cell

    Happy to help and thanks for the feedback

+ 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. Number and percentage in tables (same cell)
    By Marvin85 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-29-2016, 02:04 AM
  2. [SOLVED] Spilit a number and increase a cell value by percentage
    By sahdev in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-09-2013, 08:17 AM
  3. [SOLVED] Automatically convert number to percentage
    By mijam in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-22-2013, 07:20 PM
  4. [SOLVED] If cell value is percentage then... else if it is a whole number then...
    By dougmcc1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-19-2013, 12:50 PM
  5. Convert Percentage to number
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-08-2006, 03:35 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