I would like to custom format a cell with yyyymm_xxx. Total allow is 10 digit including the space (cannot more or less). yyyy is year ,mm is month, then with a space (must) follow by 3 digit. Example 123,873,097,027
T202011a.xlsm | |||
---|---|---|---|
A | |||
1 | |||
2 | 202011 XXX | ||
3 | |||
1b |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A2 | A2 | =TODAY() |
T202011a.xlsm | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Date | Code | |||
2 | Nov 1, 2020 | 123 | 202011 123 | ||
3 | |||||
1b |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A2 | A2 | =TODAY() |
C2 | C2 | =TEXT(A2,"yyymm")&" "&B2 |