BackFill Zeros

D

dallin

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.
 
R

Ron Coderre

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
 
Top