Status
Not open for further replies.

#### shariefi

##### New Member
I have a column of numbers in a spreadsheet that are five, six or seven digits in length, and they need to be updated to all be eight digits in length by inserting leading zeros.

Is there a simple function I can write that will do this
Thanks!

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

#### Joe4

Let's say the value is in cell A1. Then here is one formula that will work:
=LEFT("00000000",8-LEN(A1)) & A1

Of course, if you just need it for visual purposes, you could simply do a custom format of: 00000000

#### Joe4

Status
Not open for further replies.

Replies
3
Views
445
Replies
1
Views
267
Replies
7
Views
395
Replies
4
Views
381
Replies
11
Views
401

1,141,681
Messages
5,707,796
Members
421,528
Latest member
datdude151

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back