Adding Zeros

H

Heather

I need to create an expression that adds zeros to the
front of field. The data looks like this;

Have Need
7 000007
22 000022
333 000333
1231 001231

Any suggestions? THANKS!!
 
D

Dale Fye

You can use the format command, similiar to:

FORMAT([yourValue], "000000")

HTH
DALE
 
Top