Community
Showing results for 
Search instead for 
Do you mean 
Reply

Custom Field Format - Numeric with leading zeros up to 0999

New Member
Posts: 2
Country: USA

Custom Field Format - Numeric with leading zeros up to 0999

Hi, I would like to set up a custom format for a numeric field. The field will contain numeric values from 1 to 5000.

Field will be used to create dynamic groups and to sort and filter so field value cannont be text.

 

I would like the field to display as follows:

From 1 to 999 like this: 0001...0999

From 1000 to 5000 like this: 1000...5000

 

How can this be done?

 

Please help me!

 

 

Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Custom Field Format - Numeric with leading zeros up to 0999

That can be done only itf you make it a character field but your would need to make all numbers 4-digits. For example 0001 through 5999.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129