Padding a number using an IF statement?

[couger77]

I need to know if it is possible to pad a number with a single digit (0)
if and only if the that number is less than 8 digits long.

Thanks!

 

[Allan Koodray]

Rather than using an If statement, why not just change the
format of the cells. Using a Custom format you can specify
the format of the number to contain a leading )

Format --> Cells --> Custom
0000000#

For example:
12345 = 00012345
1234567 = 01234567

Hope this makes it easier.

Allan Koodray

 

[Aladin Akyurek]

If you need leading zeroes hard-coded...

=TEXT(A1,"00000000")

 

[couger77]

Thanks. That worked great!

 

[couger77]

ACtually, it does not work still.
Here is the formula that is looking at the cell with 8 characters.

=DATE(RIGHT(D27,4),LEFT(D27,2),MID(D27,3,2))

If I just format it, the cell looks like it contains an extra zero, but
it is just the same number when you click on it.

 

[Aladin Akyurek]

Give some entries from D27 on, which you seem to convert into date values.