Concatenate 2 numbers

I want to concatenate 2 numeric columns into another numeric column. Taking Year and Month into YEARMONTH where YEARMONTH is still a number and not text. 2023 and 07 as number 202307

Find more posts tagged with

Accepted answers

Georgie

Try adding VALUE before the concatenation to convert it to a number.

All comments

Georgie

Try adding VALUE before the concatenation to convert it to a number.

You need to Enable Javascript to Leave a Comment.