Yecart77
New Member
- Joined
- Nov 8, 2022
- Messages
- 20
- Office Version
- 365
- 2021
- 2019
- 2016
- Platform
- Windows
Hi All,
Thank you in advance for any guidance anyone can give. I think it will be simple but I cannot work it out.
Sample photo (couldn't get XL2BB to work) created with 365 but formula need for a doc on 2016.
Wanting to create a unique identifier in Column A for a data set that I want to be in the format of:
ABCD-0001/2023 <-- with four numbers to the left of the forward slash at all times, even if the number is 1,2 or 3 digits.
="ABCD-"&""&ROW()-ROW($A$1)&"/"&$K$1
Formula I currently have, noting K1 has the /year parked in it.
How do I 'pad' the numbers to be always four digits, nested within a ROW formula.
I have had a go at using TEXT and REPT but cannot get it to work.
Thank you in advance for any guidance anyone can give. I think it will be simple but I cannot work it out.
Sample photo (couldn't get XL2BB to work) created with 365 but formula need for a doc on 2016.
Wanting to create a unique identifier in Column A for a data set that I want to be in the format of:
ABCD-0001/2023 <-- with four numbers to the left of the forward slash at all times, even if the number is 1,2 or 3 digits.
="ABCD-"&""&ROW()-ROW($A$1)&"/"&$K$1
Formula I currently have, noting K1 has the /year parked in it.
How do I 'pad' the numbers to be always four digits, nested within a ROW formula.
I have had a go at using TEXT and REPT but cannot get it to work.