Concatenate Format Result

[rettingr]

I am trying to concatenate cells that contain a Date, Text and Dollar amounts. I want the result to be formatted a certain way when it comes out the other end and a simple concatenate formula is putting the date and dollars in its simplest form. I am attaching a sample and the first line shows the result, but only when the source cells are formatted and filled with text data. This isn't an option as I would have to retype large quantities of data to make it work. Any solutions? Using Excel 2003 by the way.

[HansV]

You can use the TEXT function to format the parts:

=TEXT(A2,"d mmm yy")&D2&B2&D2&TEXT(C2,"$#,##0.00")

or

=CONCATENATE(TEXT(A2,"d mmm yy"),D2,B2,D2,TEXT(C2,"$#,##0.00"))

[rettingr]

Yes, Hans. As always that works most wonderful. The second option was best as I need to repeat it on three sheets for up to 600 lines and autofilling the formula down 450+ rows is quick after you get the first one the work correctly. And sorry for the late reply, but the budget is due based on the inputs of this spreadsheet.

Many thanks!