Decimal point filter

[mulligh]

I have a series of numbers in a field like this:

6.10
7.12
8.100
8.101
8.102
9.10
9.11
10.10
10.20

This was originally set as a text field, but it wouldn't sort the numbers correctly, so I changed it to a currency field. Now, however, if the decimal place is set to "auto", the third digit doesn't display. If I set it to "3", then every number that has only two decimal places has a zero on the end: 6.100, 7.120. Is there any way to just display what is entered and be able to sort them in numerical order as above?

Thanks.

 

[randy700]

Set the field size to Double. You don't need anything in the Format property, but it can be General Number.



Randy