Number Display
I want to display values in the following manner -- if a
respondent enters a decimal place it will automatically chop the decimal place without rounding the number up (for example, 49.9 will display as 49 instead of 50). At the same time I want to be able to have -49.9 recognized as a number. What format would be good for this? There must be a way to customize/format the cell to do both of these things. Thanx in advance. |
Number Display
I don't think there is any number format that truncates for display
purposes; I think they all round. -- Jim Rech Excel MVP |
All times are GMT +1. The time now is 08:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com