Sure, I can definitely help you with that!
The number you see in
column O2 is actually the serial number that Excel uses to represent dates. To convert it to the format you want (
yyyymmdd), you can use the
TEXT function in Excel.
Here's the formula you can use:
- =CONCATENATE(TEXT(O2,"yyyymmdd"),"-",B2)
Let me break it down for you:
- The
TEXT function takes two arguments: the value you want to format (in this case, O2), and the format you want to apply (in this case, "yyyymmdd").
- The
"yyyymmdd" format tells Excel to display the year, month, and day in that order, without any separators.
- We then concatenate the formatted date with the hyphen and the value in column B2, just like you were doing before.
So if O2 contains the date March 18, 2010, the formula will output "
20100318-3042".
I hope that helps!