auto.pilot
Well-known Member
- Joined
- Sep 27, 2007
- Messages
- 734
- Office Version
- 365
- Platform
- Windows
Using XL07, my range of cells is populated with both positive and negative numbers. I'd like to format the output such that any number between -1 and 1 is displayed with one decimal place and any number outside of that range is formatted with no decimal place. ie:
1.00 or higher format as 1
-1.00 or lower, format as -1
A number between these, say -.52 would format as -.5
Using Cells>Format Cells>Number>Custom, I input [1].#,# which works for any number over 0. How would I capture the negative numbers, which may from time to time populate the same cells.
Thanks
jim
1.00 or higher format as 1
-1.00 or lower, format as -1
A number between these, say -.52 would format as -.5
Using Cells>Format Cells>Number>Custom, I input [1].#,# which works for any number over 0. How would I capture the negative numbers, which may from time to time populate the same cells.
Thanks
jim