+ Reply to Thread
Results 1 to 8 of 8

Formula for "Accounting" Format to be RED with $ Sign Aligned to the Left

  1. #1
    Registered User
    Join Date
    04-20-2020
    Location
    Vancouver
    MS-Off Ver
    365
    Posts
    4

    Formula for "Accounting" Format to be RED with $ Sign Aligned to the Left

    Hello!

    Is there a formula that will be change the "accounting" format to stay red and in brackets (negative) with the $ sign aligned to the left of the cell (instead of right next to the number)?

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Formula for "Accounting" Format to be RED with $ Sign Aligned to the Left

    Please post an excel file with the question in it.

    Show the expected result manualy in your file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Formula for "Accounting" Format to be RED with $ Sign Aligned to the Left

    right click on the cell/s ---> Format Cells --->custom--->

    Type: _-$#,##0;[Red]-(_-$#,##0)
    Last edited by Limor_OP; 04-20-2020 at 05:51 PM.

  4. #4
    Registered User
    Join Date
    04-20-2020
    Location
    Vancouver
    MS-Off Ver
    365
    Posts
    4

    Re: Formula for "Accounting" Format to be RED with $ Sign Aligned to the Left

    Hi thank you!

    I'm looking for the $ sign to appear outside of the bracket aligned to the left of the cell.

  5. #5
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Formula for "Accounting" Format to be RED with $ Sign Aligned to the Left

    Please type here how you would like it to be seen?

    -$(2500) [in red] ? or
    $(2500) [in red]
    or otherwise...

  6. #6
    Registered User
    Join Date
    04-20-2020
    Location
    Vancouver
    MS-Off Ver
    365
    Posts
    4

    Re: Formula for "Accounting" Format to be RED with $ Sign Aligned to the Left

    $ (2500) [in red]

    but I'd like the $ sign to be aligned to the left of the cell like it does in the "accounting" format.

    sorry, it won't let me know upload a file to show a sample.

  7. #7
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Formula for "Accounting" Format to be RED with $ Sign Aligned to the Left

    you can use this in format cells, custom, type:

    _-[$$-409]* #,##0_ ;[Red]_-[$$-409]* (#,##0) ;_-[$$-409]* "-"??_ ;_-@_

  8. #8
    Registered User
    Join Date
    04-20-2020
    Location
    Vancouver
    MS-Off Ver
    365
    Posts
    4

    Re: Formula for "Accounting" Format to be RED with $ Sign Aligned to the Left

    Thank you so much!!

+ 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. accounting format for zero show 0.00 in one cell "-" in another
    By SundanceKidLudwig in forum Excel General
    Replies: 6
    Last Post: 10-24-2021, 08:39 AM
  2. Replies: 35
    Last Post: 01-13-2016, 02:16 AM
  3. [SOLVED] Expanded and collapsed the rows by toggle "+" or "-" sign on left of the text
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-24-2013, 02:49 PM
  4. Vlookup LEFT of the "^" sign, IF "^" is present in the string
    By ConstantinV in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-02-2013, 03:26 PM
  5. [SOLVED] Macro to find sign "@" and change format of email address
    By xtasio in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-22-2012, 04:17 AM
  6. Replies: 11
    Last Post: 08-16-2012, 09:49 AM
  7. Applying a "Left" formula to an entire column with heading "ValueCol"
    By aad401 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2012, 04:14 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