+ Reply to Thread
Results 1 to 13 of 13

Formatting numbers for calculating the per centage

  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    70

    Formatting numbers for calculating the per centage

    Hi

    what could be the format of numbers for calculating the percentate?

    Ex: 4.454,53 I am calculating formula =( 4.454,53*.2)

    it was throwing error messge #value.

    regards
    Odaiah

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Formatting numbers for calculating the per centage

    that would be because its text your regional settings do not match . as thousands separator and , for decimals
    you cold try
    =SUBSTITUTE(SUBSTITUTE(A1,".",""),",",".")*0.2
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,556

    Re: Formatting numbers for calculating the per centage

    Congrats on the 15k, martin
    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

  4. #4
    Registered User
    Join Date
    06-13-2012
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    70

    Re: Formatting numbers for calculating the per centage

    Hi
    Please let me know I need assign the marks. How to do it.

    I appreciate your help and co-operation.

    Regards
    Odaiah Pelley

  5. #5
    Registered User
    Join Date
    06-13-2012
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    70

    Re: Formatting numbers for calculating the per centage

    Hi Martin,

    It worked only for 20% I need to change for 27% .27 it was throwing error.

  6. #6
    Registered User
    Join Date
    06-13-2012
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    70

    Re: Formatting numbers for calculating the per centage

    Hi FDibbins,

    Thank you for the help. I appreciate it. formula worked well for 20% but when I assigned few columns are 27% some others are 35%.
    cell is not accepting .27 or .35

    Regards
    uday

  7. #7
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Formatting numbers for calculating the per centage

    what are your regional settings in control pan/region
    if a column is in % then select column data /text to columns click finish

  8. #8
    Registered User
    Join Date
    06-13-2012
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    70

    Re: Formatting numbers for calculating the per centage

    I am attaching the excel file
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    06-13-2012
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    70

    Re: Formatting numbers for calculating the per centage

    Hi

    Could you please send me the screen shots for below requirement? I don't what are setting for it.

    what are your regional settings in control pan/region
    if a column is in % then select column data /text to columns click finish

    Regards
    Uday

  10. #10
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Formatting numbers for calculating the per centage

    i cant see anything in that workbook not working

  11. #11
    Registered User
    Join Date
    06-13-2012
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    70

    Re: Formatting numbers for calculating the per centage

    Hi

    ok, How to make the settings for it?
    Where I have to go to check it?

    Please send me the screen shot of it.

    Regards
    Uday

  12. #12
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Formatting numbers for calculating the per centage

    i take it you are using a windows pc then its in the windows settings nothing to do with excel
    start/control panel/regional options or google regional settings for your version of windows
    but i repeat what is on that sheet that is not working

  13. #13
    Registered User
    Join Date
    06-13-2012
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    70

    Re: Formatting numbers for calculating the per centage

    Hi

    Thank you for your help. My problem is solved.

    Regards
    Odaiah Pelley

+ 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. [SOLVED] Conditional formatting - formatting the lowest 2 numbers in a list of 12 numbers
    By ktbb0312 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-09-2013, 09:59 AM
  2. Calculating numbers within number?
    By pthomas77 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2013, 12:11 PM
  3. Replies: 9
    Last Post: 03-26-2012, 02:16 PM
  4. Calculating Certain Numbers
    By mattpritch in forum Excel General
    Replies: 7
    Last Post: 10-16-2009, 02:25 PM
  5. [SOLVED] calculating the difference between 2 numbers
    By Darran in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 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