Hi
I have a column which is a reference and could include dates, texts and numbers as the reference.
I need to concatenate as "BATCH "&cell reference
Example of data in reference column:
45454
01/10/2023, giving
BATCH 45454
BATCH 01/10/2023
="BATCH "&TEXT(G34,"DD-MMM-YY") gives me a date format when a date but will then also date format the 45454.
Is it possible to distinguish in a formula between when a number is formatted as a date or formatted as a number to give the above result ?
Thanks
Steve
I have a column which is a reference and could include dates, texts and numbers as the reference.
I need to concatenate as "BATCH "&cell reference
Example of data in reference column:
45454
01/10/2023, giving
BATCH 45454
BATCH 01/10/2023
="BATCH "&TEXT(G34,"DD-MMM-YY") gives me a date format when a date but will then also date format the 45454.
Is it possible to distinguish in a formula between when a number is formatted as a date or formatted as a number to give the above result ?
Thanks
Steve