View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
pm pm is offline
external usenet poster
 
Posts: 122
Default need to convert microsoft date to yyyymmdd

That works excellent, thanks! I tried using the text function too, but
couldn't get it to work. Thanks again for your help!

"Dave Peterson" wrote:

=text(o2,"yyyymmdd")&"-"&b2
or maybe...
=text(o2,"yyyymmdd")&"-"&text(b2,"0000")

To make sure that that vendor is 4 digits, too.

pm wrote:

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?


--

Dave Peterson
.