Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 154
  • Last Modified:

I lost my 00000's! Where did they go?

I have a field that our data entry people key that needs to have 5 digits, most beginning with 1-3 zero's. How can I make it keep the zero's and also make it have 5 digits? i.e. they enter 34, it should convert to 00034.
0
aeonflux2
Asked:
aeonflux2
  • 2
1 Solution
 
gingerdebCommented:
Try using the formula below:
@Text(@Right("00000" + @Text(NumericField); 5))

Deb
0
 
AndrewJayPollackCommented:
A text field, or if you're using a recent version of notes the properties for the field allow you to define the number format on the field definition and also in the view column.
0
 
aeonflux2Author Commented:
Neither of these seem to work.

Gingerdeb, am I putting the formula in the wrong place? I entered it into input translation, and it erases what I entered and replaces it with 5 zero's.

I am in Lotus R5, and I have Number as the property, but that won't add the preceeding zero's.
0
 
gingerdebCommented:
Yes, put the formula in the input translation event of the field concerned.  I forgot to mention that you should replace "NumericField" with the name of the field.

Deb
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now