Formulas-Making a number a standard amount of digits
 

I am wondering how to make cells in a formula automatically 4 digits long?
The actual formula I am using is "=$B$6 & "-" & A15 & "-" & B15 & "-" & C15".
If the C15 cell is say, "003", in the formula it comes out "3". I need 3
digits for the last part of the whole formula in the column. Any help would
be greatly appreciated! Thanks!

Tim

Formulas-Making a number a standard amount of digits
 

Try this:

=$B$6&"-"&A15&"-"&B15&"-"&TEXT(C15,"000")

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Stiller312" wrote in message
...
I am wondering how to make cells in a formula automatically 4 digits long?
The actual formula I am using is "=$B$6 & "-" & A15 & "-" & B15 & "-" &
C15".
If the C15 cell is say, "003", in the formula it comes out "3". I need 3
digits for the last part of the whole formula in the column. Any help
would
be greatly appreciated! Thanks!

Tim

Formulas-Making a number a standard amount of digits
 

=$B$6 & "-" & A15 & "-" & B15 & "-" & TEXT(C15,"000")
--
David Biddulph

"Stiller312" wrote in message
...
I am wondering how to make cells in a formula automatically 4 digits long?
The actual formula I am using is "=$B$6 & "-" & A15 & "-" & B15 & "-" &
C15".
If the C15 cell is say, "003", in the formula it comes out "3". I need 3
digits for the last part of the whole formula in the column. Any help
would
be greatly appreciated! Thanks!

Tim

Formulas-Making a number a standard amount of digits
 

Wonderful, Thanks!

"Ron Coderre" wrote:

Try this:

=$B$6&"-"&A15&"-"&B15&"-"&TEXT(C15,"000")

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Stiller312" wrote in message
...
I am wondering how to make cells in a formula automatically 4 digits long?
The actual formula I am using is "=$B$6 & "-" & A15 & "-" & B15 & "-" &
C15".
If the C15 cell is say, "003", in the formula it comes out "3". I need 3
digits for the last part of the whole formula in the column. Any help
would
be greatly appreciated! Thanks!

Tim

Formulas-Making a number a standard amount of digits
 

Wonderful, Thanks!

"David Biddulph" wrote:

=$B$6 & "-" & A15 & "-" & B15 & "-" & TEXT(C15,"000")
--
David Biddulph

"Stiller312" wrote in message
...
I am wondering how to make cells in a formula automatically 4 digits long?
The actual formula I am using is "=$B$6 & "-" & A15 & "-" & B15 & "-" &
C15".
If the C15 cell is say, "003", in the formula it comes out "3". I need 3
digits for the last part of the whole formula in the column. Any help
would
be greatly appreciated! Thanks!

Tim