Date formatting

I am writing a QIF file to import into MYOB and I need to change the date field from 01/08/2010 to D01/08/2010. When I simply edit the cell and put the D in front of the date this works fine, however there is a lot to do and I am wanting to do the following

Date Coloumn {D1} Extra coloumn (with just D in it) {B1} and then simply use the formula B1&D1 and it should give me the result of D01/08/2010 - problem is no matter what I do, as soon as I use the formula, the date is changing to text format so I get D40391. No matter how I change the format of the final cell it wont work.

I hope I have explained what I am trying to do - I would do a little example and attach but I am a bit lost as to how as I am brand new around here and still learning.

Any assistance would be fantastic

Many thanks
Lee-Anne

You can do a few things.

One option would be a custom format of "D"mm/dd/yyyy.

Another option is to use the formula ="D" & Text(D1,"mm/dd/yyyy")