+ Reply to Thread
Results 1 to 7 of 7

Custom formating numbers

  1. #1
    Registered User
    Join Date
    01-11-2012
    Location
    sweden
    MS-Off Ver
    Excel 2007
    Posts
    47

    Custom formating numbers

    Hi,

    Could you please provide custom formatting for
    910,664 to appear as 911
    -541,190 to appear as (541)
    1,230,456 to appear as 1,230
    -2,534,610 to appear as (2,534

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Custom formating numbers

    try
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by humdingaling; 05-30-2017 at 10:17 PM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Custom formating numbers

    sorry
    with the comma for millions
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Custom formating numbers

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    http://chandoo.org/forum/threads/cus...numbers.34565/
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  5. #5
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Custom formating numbers

    You can use the Custom Format option by selecting the range, formatting the cells, and in Custom, enter #,;(#,)

    Note: This will return 2535 for the last number - you said you wanted 2534

    I notice I lose the coma - I'm working on that! Just noticed humdingaling posted before me with similar answer, and also fixed the coma thing.



    Regards,

    David

    If this has been helpful
    - Please click on the *Add Reputation button at the bottom left.

    Please mark your thread as SOLVED:
    - Click Thread Tools above your first post, select "Mark your thread as Solved".

    Last edited by David A Coop; 05-30-2017 at 10:34 PM.

  6. #6
    Registered User
    Join Date
    01-11-2012
    Location
    sweden
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Custom formating numbers

    Thank you Huming. It worked but when I applied the custom to number $438
    it returned nothing. Would want to see (0.438)

    Apologies alan, I will keep this in mind
    Thank you Savid

  7. #7
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Custom formating numbers

    that wasn't in your original specs.....

    not sure why is 438 would be negative but anyway
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    and no you cannot have more than 3 types/brackets...if you want more you have to be "creative" and determine what format to apply like what was suggested by Alan on Chandoo

+ 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. Custom formating
    By InvalidTxtString in forum Excel General
    Replies: 2
    Last Post: 08-24-2016, 02:30 PM
  2. Custom date formating
    By carbon_kid85 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-07-2014, 10:34 AM
  3. Request Custom formating
    By raj1234 in forum Excel General
    Replies: 3
    Last Post: 11-20-2008, 11:07 AM
  4. Custom Cell formating
    By maacmaac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-14-2008, 09:18 AM
  5. custom formating
    By bob12 in forum Excel General
    Replies: 3
    Last Post: 01-26-2007, 01:04 PM
  6. custom formating text
    By Mart in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-25-2005, 09:05 AM
  7. Custom formating won't work
    By Marty in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-06-2005, 12:06 PM

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