supermom28115
New Member
- Joined
- May 9, 2022
- Messages
- 43
- Office Version
- 365
- Platform
- Windows
Attempting to create the first four digits of an item code for a product log using =text(a1, "mm") where a1 has transaction date 9/16/2023 but I only want the month in a two digit format with a two digit autonumber from another cell using the =Row(A1) with a custom number format of 00. I have tried using concat and the =text(a1,"mm") with & but it just will not give me a two digit month only. I end up with 9/16/202301
What am I doing wrong?
DATE | PROD # | AUTONUMBER |
9/16/2023 | =ROW(A1) CUSTOM FORMAT 00 | |
9/22/2023 | =ROW(A2) " " | |
What am I doing wrong?