# Combining Numbers that Have Leading Zeros

1. ## Combining Numbers that Have Leading Zeros

Hi,
Thank you very much for letting me know about TEXT function. It was very helpful in solving one of main problem in displaying leading zeros using ASP in excel. Thanks again.

Cheers,
Ravee

2. ## Combining Numbers that Have Leading Zeros

Problem:

Column A (List1) is formatted to display a leading zero before each number. That is, \"1\" is displayed as \"01\", \"2\" as \"02\", and so on.
The following formula was created to concatenate the numbers from List1 into one string:
=A2&A3&A4&A5
However, an incorrect result of \"1234\" is returned.
How can we modify the formula to honor the leading zeros?

Solution:

Use the TEXT function as shown in the following formula:
=TEXT(A2,\"00\")&TEXT(A3,\"00\")&TEXT(A4,\"00\")&TEXT(A5,\"00\")

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1