| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
(month) 2 digits in formula
Hi! there,
I appreciate if someone can help me to solve this. I have formula in A2,3,4.. cell like =IF(B2="","",YEAR(B2)&"-"&MONTH(B2)&"-"&($A$1+C2)&"AT"). 0 2009-3-1AT 06-Mar-09 1 2009-3-2AT 07-Mar-09 2 2009-3-3AT 08-Mar-09 3 I want the result to be "2009-03-01AT" instead of "2009-3-1AT". I have no idea how to format 2 digits in month place. Thanks in advance Bradley |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to sum the digits | Excel Worksheet Functions | |||
| How to display month in 2 digits? | Excel Discussion (Misc queries) | |||
| How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
| Trying to get a Boolean formula to work month-to-month | Excel Discussion (Misc queries) | |||
| month & year format in two digits | Excel Discussion (Misc queries) | |||
Threaded Mode
