How to show a permenant number format in cells when I pull in my data from a que

Question

How to show a permenant number format in cells

when I pull in my data from a query the "0" from the code "0123" always gets removed when brought into excel, I know I can change is using customer formatting (0000) but here is the problem..

When I join 2 cells to create a single cell output

Example A1 cell equals 0123 (which I have made using the format option (0000) and cel B1 equals AZ123456

and use =A1&"-"&B1

I get this result in cell C1 = 123-AZ123456

desired result is C1 = 0123-AZ123456

Not all data in Col A needs a "0" in front just the parts that have it, some other parts are 9876, or 4567, 3214. Ifs just the parts that start with "0" I have the problem with

How can I get this to work??

Thanks!

Explanation / Answer

Hi,

Use this formula:

=TEXT(A1,"0000")&"-"&B1

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.