LinkBack URL
About LinkBacks
I have a custom formatted cell that looks like this: #,##0.0,,;;"-" However, when a value in that cell is negative, the cell is just left blank. I want the custom format to display negative values. I am on Excel 2010.
I have a custom formatted cell that looks like this: #,##0.0,,;;"-" However, when a value in that cell is negative, the cell is just left blank. I want the custom format to display negative values. I am on Excel 2010.
structure of number format is Positive;Negative;Zero;Text
#,##0.0,-#,##0.0,;;"-"
This Format with a couple extra ","'s worked thank you.Originally Posted by Andy Pope
Last edited by HCLax; 07-07-2014 at 10:28 AM.
It should have been
#,##0.0;-#,##0.0;;"-"
I left a couple of commas in thereby mistake.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks