Adding leading zeros to established text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of numbers stored as text, they need to remain that way, I need
to add zeros to all of the values so that they will all be 5 digits.

Is there a way to do this in an update query?
 
Karl's does work. You can also use my favorite "Format" (the same as "Text'
in Excel) Format ([FieldName],"00000"). I use it alot were I have to join a
11 digit to a 13 digit UPC. I also use it in a concatenate expression for
two or more fields. For example: ([QTY] & "/" & Format ([PRICE],"$0.00")),
resulting in 2/$5.00.

--
Thanks, Kevin


KARL DEWEY said:
Update with this --

Right("0000"&[YourTextField],5)

Larry G. said:
I have a list of numbers stored as text, they need to remain that way, I need
to add zeros to all of the values so that they will all be 5 digits.

Is there a way to do this in an update query?
Click to expand...
Click to expand...
 
You must log in or register to reply here.

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

Similar Threads

Add A Leading Zero 4
validation rule for exactly 5 digits, including leading zeros 0
Restore leading zero 3
LEADING ZEROS 7
Export of text field trims leading zeros 1
Remove leading zeros 2
Adding in leading zeros and a space to a text field in a table 4
Droping Leading Zeros In Table 4

Back
Top