Custom date format

[mhtan]

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

 

[Dave Patton]

Your example is not clear.
My example shows today's date custom formatted with yyyymm" XXX"

T202011a.xlsm
	A
1
2	202011 XXX
3
1b

Cell Formulas
Range	Formula
A2	A2	=TODAY()

 

[Fluff]

Cross posted Date format customization

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered elsewhere.

 

[mhtan]

Thanks.

I understand how to make the formula yyyymm, but to add in the sptring ,I will need to have a space follow by 3 numbers(only). In fact, it is a batch number standard format set of a manufacture product. It will be vapture in a system for QR code too.

This is use for a data base for my staffs to enter for the purpose of label printing. We have many issue where the format key in by my staffs has errors result the system could not read.

 

[Dave Patton]

mhtan​

Another guess since you have not provided information so that we can answer your question.

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