trailing Zeroes

V

Vince Evans

Hello, I need to format a field to six spaces. I have a
field that is various length. For eg. Person Id is the
field and some have three digits , some four, some five. I
need to format with trailing zeroes. If Person ID
=123,then in need to show 123000, if Person id is 2565,
then 256500, if Person Id 36987, then 369870. THanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top