Fit to cell width(Formatting Issue)

building reports webintelligence
1

I have issue with formatting a cell. I did horizontal padding and vertical padding to be 0 and wrap text also.Even then there is a space in front of the number displayed in each cell.I want the number to exactly fit in the cell.How can i do this?I try to undo wrap text and reduce the cell width but the number becomes #### and am not able to see it.What else can i try so that i do not see any space left or right after the number displays in the cell.

Thanks
–H

hourigan (BOB member since 2007-04-06)

2

The extra space is probably reserved for the potential minus sign for negative numbers.

Dave Rathbun :us: (BOB member since 2002-06-06)

3

Even when i just hardcode a particular number in cell as attached i still get the space before the number.In this case there is no possibility that there will be a negative number as its hardcoded? Do you think in this case also its reserving the space for sign?

Thanks,

__h

hourigan (BOB member since 2007-04-06)

4

Yes, because it’s formatted as numeric. Try creating a custom format so that numeric values do not have a - sign, using only colors no () or anything and see if that displays differently… but I would not suggest this because if you lose the color (via printing) you will be misleading the readers.

Dave Rathbun :us: (BOB member since 2002-06-06)