Preserve padded numbers when combining with text?

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Flair (click to view more posts with a particular flair)

solved

Post Body

Padded numbers are very useful to me. Padded numbers like 010, 007, 000286, etc. I want a formula to create a series of labels like "Document 002" or "Exhibit 0101." But the formula/method I'm using loses the padding. I'm combining a text cell with a number cell. I keep getting "Example5" instead of "Example00005". Got to be an easy way to do this, no?

What I'm doing:

A Column: (whatever label) "Document_"

B Column: (padding the zeroes through the custom number option) "000001"

C Column: "=concat(A1,B1)". But this gives me "Document_1" not "Document_000001"

What do? Thanks in advance!

Author

Account Strength

80%

Account Age

8 years

Verified Email

Yes

Verified Flair

Total Karma

354

Link Karma

156

Comment Karma

188

Profile updated: 1 day ago

Posts updated: 1 week ago

MadPoet440

Subreddit

r/excel

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 2 years ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/excel/comme...