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)?
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)?
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.
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.
Hi thank you!
I'm looking for the $ sign to appear outside of the bracket aligned to the left of the cell.
Please type here how you would like it to be seen?
-$(2500) [in red] ? or
$(2500) [in red]
or otherwise...
$ (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.
you can use this in format cells, custom, type:
_-[$$-409]* #,##0_ ;[Red]_-[$$-409]* (#,##0) ;_-[$$-409]* "-"??_ ;_-@_
Thank you so much!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks