LEADING ZEROS IN FORMULA RESULT
 

I have looked all over to determine how to maintain leading zeros in a
formula result. I have tried formating cells as custom '0000' and as text to
no avail. I have two cell that I would like to combine into one cell.
Example, b1=60; c1=07 when I combine these two cells I get a1=607... This is
killing me. Any quick help would be greatly appreciated.

LEADING ZEROS IN FORMULA RESULT
 

You can use =text(location,"00000") this will always put zeroes in front if
needed to make number 5 digits, increase zeroes for more.

-John

"Advent" wrote:

I have looked all over to determine how to maintain leading zeros in a
formula result. I have tried formating cells as custom '0000' and as text to
no avail. I have two cell that I would like to combine into one cell.
Example, b1=60; c1=07 when I combine these two cells I get a1=607... This is
killing me. Any quick help would be greatly appreciated.

LEADING ZEROS IN FORMULA RESULT
 

Thanks John but I am looking to combine these two numbers. I would like to
end up with 6007.

"John Bundy" wrote:

You can use =text(location,"00000") this will always put zeroes in front if
needed to make number 5 digits, increase zeroes for more.

-John

"Advent" wrote:

I have looked all over to determine how to maintain leading zeros in a
formula result. I have tried formating cells as custom '0000' and as text to
no avail. I have two cell that I would like to combine into one cell.
Example, b1=60; c1=07 when I combine these two cells I get a1=607... This is
killing me. Any quick help would be greatly appreciated.

LEADING ZEROS IN FORMULA RESULT
 

This will work if you know how many leading zeroe's you want
=TEXT(A1,"00")&TEXT(B1,"00")

-John

"Advent" wrote:

Thanks John but I am looking to combine these two numbers. I would like to
end up with 6007.

"John Bundy" wrote:

You can use =text(location,"00000") this will always put zeroes in front if
needed to make number 5 digits, increase zeroes for more.

-John

"Advent" wrote:

I have looked all over to determine how to maintain leading zeros in a
formula result. I have tried formating cells as custom '0000' and as text to
no avail. I have two cell that I would like to combine into one cell.
Example, b1=60; c1=07 when I combine these two cells I get a1=607... This is
killing me. Any quick help would be greatly appreciated.

LEADING ZEROS IN FORMULA RESULT
 

John,
You are the man! Thanks so much this really worked.

"John Bundy" wrote:

This will work if you know how many leading zeroe's you want
=TEXT(A1,"00")&TEXT(B1,"00")

-John

"Advent" wrote:

Thanks John but I am looking to combine these two numbers. I would like to
end up with 6007.

"John Bundy" wrote:

You can use =text(location,"00000") this will always put zeroes in front if
needed to make number 5 digits, increase zeroes for more.

-John

"Advent" wrote:

I have looked all over to determine how to maintain leading zeros in a
formula result. I have tried formating cells as custom '0000' and as text to
no avail. I have two cell that I would like to combine into one cell.
Example, b1=60; c1=07 when I combine these two cells I get a1=607... This is
killing me. Any quick help would be greatly appreciated.