P
pm
I have a file in which I concatenate two fields, the vendor and the date.
it shows as 40255-3042
I would like 20100318-3042
Here's my formula: =concatenate(O2,"-",B2)
Can anyone help me format the date field I am picking up in column O2?
it shows as 40255-3042
I would like 20100318-3042
Here's my formula: =concatenate(O2,"-",B2)
Can anyone help me format the date field I am picking up in column O2?