Hi
I have formatted values as thousands using custom formats. However small values show as 0 or (0). How do I display these as blank as i would do for zero. I would prefer not to use CF.
Thank You
Allister
Hi
I have formatted values as thousands using custom formats. However small values show as 0 or (0). How do I display these as blank as i would do for zero. I would prefer not to use CF.
Thank You
Allister
Your format displays zero values as
-
not blank. If you want to use this symbol for any number under 1000, modify your custom format
Formula:Please Login or Register to view this content.
If you want to display zeroes truly as blank then use this custom format:
Formula:Please Login or Register to view this content.
However for negative numbers it will still show a "-"
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks