|
» Combining Numbers that Have Leading Zeros
CATEGORY: Excel Text Formulas |
VERSIONS: All Microsoft Excel Versions |
|
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") |
|
RATING:
4.63
VIEWS: 17652 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- Microsoft Excel 2002 Formulas (With CD-ROM)
- East of Eden (Oprah's Book Club)
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Microsoft Excel 2002 Simply Visual
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
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