+ Reply to Thread
Results 1 to 4 of 4

Custom % Format Help Request

  1. #1
    Registered User
    Join Date
    12-02-2012
    Location
    Miami
    MS-Off Ver
    2019, 365, MAC
    Posts
    45

    Custom % Format Help Request

    I am trying to create a custom number format.
    Here is what I have come up with: 0.00%;[Red]-0.00%
    The problem is, it has no "," it would display as 23555555.6% or -2355555.6%(negative needs to be red)

    I need it to display as: 23,555,555.6% or -23,555,555.6%(negative needs to be red)
    How would this be written?

    Additionally, I have occasion to "abbreviate" in the following format:
    23.55MM% or 1.5M% or -23.55MM% or -1.5M%(negative needs to be red)
    For currency, I have it written in this manner: Currency: [>=1000000] $#,##0.0,," MM";[>0] $#,##0.0," M";[Red]($#,###," M")
    I just freeze when trying to convert to percentage.

    Can anyone help?

    Thank you so much in advance for your assistance.

  2. #2
    Registered User
    Join Date
    02-09-2014
    Location
    New York
    MS-Off Ver
    Excel 2013
    Posts
    84

    Re: Custom % Format Help Request

    Try custom formatting #,##0.0%

  3. #3
    Registered User
    Join Date
    02-09-2014
    Location
    New York
    MS-Off Ver
    Excel 2013
    Posts
    84

    Re: Custom % Format Help Request

    Try custom formating #,##0.0% and or #,##0," mm"%

  4. #4
    Registered User
    Join Date
    12-02-2012
    Location
    Miami
    MS-Off Ver
    2019, 365, MAC
    Posts
    45

    Re: Custom % Format Help Request

    Thank you so much. So easy, yet beyond me tonight.

+ 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] Currency Format Request
    By dbsbender in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-18-2014, 09:42 PM
  2. Request a format cell E042=.....MT
    By choy96 in forum Excel General
    Replies: 3
    Last Post: 09-23-2011, 12:22 PM
  3. Request Custom formating
    By raj1234 in forum Excel General
    Replies: 3
    Last Post: 11-20-2008, 11:07 AM
  4. Conditional Format-How can I request a cell containing anything
    By Gunjani in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-18-2006, 07:35 AM
  5. How to format a DDE request...
    By droskill in forum Excel General
    Replies: 0
    Last Post: 04-09-2005, 01:32 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