| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
| Type set amount of digits in one cell then automatically move to n | Excel Worksheet Functions | |||
| Limit the amount of digits displayed in a field in Excel or Access | Excel Discussion (Misc queries) | |||
| Format monetary amount to 9 digits with No decimals without rounding | Excel Worksheet Functions | |||
| Array Formulas for Geometric Standard Deviation and Sharpe | Excel Worksheet Functions | |||
Hybrid Mode
