BackFill Zeros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dallin - 31 Oct 2006 18:37 GMT

I have data that looks like this 123 but I need it to be back filled with
zeros so it looks like this 00123. I there a function that does that in a
formula? Thanks.

Reply to this Message

Ron Coderre - 31 Oct 2006 18:48 GMT

Try this:

With
A1: (a numeric value)

You can either....

Use a custom number format:
Select A1
From the Excel main menu:
<format><cells><number tab>
Category: custom
Type: 00000
click the [OK] button

OR
Use this formula...
B1: =TEXT(A1,"00000")

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

> I have data that looks like this 123 but I need it to be back filled with
> zeros so it looks like this 00123. I there a function that does that in a
> formula? Thanks.

Reply to this Message