| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding function
Hello,
How can I add "00" & "0" to the the following cells: (A B ) Result C D (1 72 ) 001 072 Regards, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding function
Try a custom format of 000
Mike "John" wrote: Hello, How can I add "00" & "0" to the the following cells: (A B ) Result C D (1 72 ) 001 072 Regards, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding function
Try...
C1, copied to D1: =TEXT(A1,"000") Hope this helps! In article , John wrote: Hello, How can I add "00" & "0" to the the following cells: (A B ) Result C D (1 72 ) 001 072 Regards, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Time Function | Excel Worksheet Functions | |||
| PivotTable -adding more than one function | Excel Worksheet Functions | |||
| Adding a new comment with a function? | Excel Discussion (Misc queries) | |||
| Help with adding certain cells using an IF function | Excel Worksheet Functions | |||
| Adding text before a function | Excel Worksheet Functions | |||
Linear Mode
