johnrh Posted November 22, 2002 Share Posted November 22, 2002 I have a number iield which is currently formated to two decimal places. I need it to show a leading zero if the data is less than 10. For example. Suppose the data is 1.45 I need the format to show 01.45. However if the data is greater than 10 then I just want it to show the data - i.e. no additional zeros. Anybody goy a suggestion to what should be an easy formating problem? Thanks Link to comment Share on other sites More sharing options...
CobaltSky Posted November 22, 2002 Share Posted November 22, 2002 One answer to this would be to create a calculating field to display the number of the desired format, turn 'Allow Entry into field' off, and stack it on top of your existing number field. That way, when you tab to the field or click into it, the original value will be displayed (and may be edited), but at all other times, the calc value will be what is displayed. In this respect, the functionality will appear to be the same as an auto-format applied to the field, but the difference is that you get total control over what is displayed. If the calculation is unstored, the impact on file size will be negligible. You could, for instance, create and use a formula along the lines of: Right("00" & Int(Number), Max(2, Length((Int(Number))))) & "." & Right(((Round(Number - Int(Number), 2) * 100) + 100), 2) Which would permit your number to exceed 99, but would nevertheless place a leading zero on all numbers less than 10, plus would extend to two decimal places for all cases (including zeros - so 0 would be displayed as 00.00). As well as turning 'Allow entry' off for the calculation field, you should ensure that the calculation field has 'Leave data formatted as entered' (if you have chosen a result type of number). A text 'result type' for the calc would be preferable in most cases. Link to comment Share on other sites More sharing options...
johnrh Posted November 22, 2002 Author Share Posted November 22, 2002 Your answer works an absolute treat. Thanks for the speedy reply John Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7960 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now