I'm creating a one-input data table.
One of my headings references profit, which is a negative value. I've custom formatted the cell to read "Profit/Loss" while still referencing the negative profit figure, but right now it displays as
-Profit/Loss
in the heading. How do I get rid of the negative sign?
Hi youradhere,
If that is a figure (number).. you can use ABS function to get rid of negative values.. thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks