I'm trying to create a custom number format where if my value is above 999% it will display >999%. I know how to do this if I convert my value to a string but I want to keep it as an integer if possible. Any thoughts on this would be much appreciated.
Perhaps I'm missing something but what would be the issue with creating a calculation where IF Avg([Sales])>.999 then '>999%'. Without seeing your data and workbook it's tough to give you a specific answer but if you've already found an answer, please let us know!