I want to concatenate two number fields with leading zeros.

G

Guest

I have two fields containing numbers such as 1661 and 5. I want to
concatenate them so the they appear like this...16610005. The first number
will be six digits with no leading zeros the second will be four digits
including leading zeros.
 

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

validation rule for exactly 5 digits, including leading zeros 0
Concatenate Date and Number field for Append Query 0
Need 7 digit number with differnt number of leading zeros 10
Keep Leading Zeros in Concatenation 5
How can I concatenate text with leading zeros 2
Eliminate leading numbers - Excel 2007 2
Ignore Leading Zeros in Mixed Alpha-Numeric Text Fields Select Query 5
How do I stop Excel from dropping leading zeros? 9

Top