Formatting Cells

How do I format cells in the design mode of Jet Reports? I tried using the normal Excel formatting with no luck.

Using the + sort feature, I am trying to sort a report by Vendor Numbers that are up to 4 digits, but the numbers under 1000 are returned as 2 or 3 digits rather than 4 and they are not being sorted correctly.

For example, what should be sorted as 50,1182, 2788,3252 is actually sorted as 1182, 2788, 3252, 50 because Jet Reports is using the first digit in all cases to sort.

I am used to being able to do in Excel: Format/Cells/Number/Custom Type: 0000 to add 2 leading zeros when needed, but that doesn't work.

Thanks for your help!


Please sign in to leave a comment.