Excel to Outlook Formatting

[Mousiefuzz]

I am having a problem generating an e-mail in outlook from an excel spreadsheet.
All the data is being pulled through fine except it isn't formatted the same as it is in the excel sheet.

For instance, I have the dates in Excel formatted to "dd/mmm/yyyy" but on the e-mail it is shown as "dd/mm/yy"
While that isn't much of an issue it becomes a problem with numbers:
125,000,000.00 is becoming 125000000.00 which is almost unreadable.

Can anyone help me fix this problem, the only two places I'm having formatting issues is the dates and numbers, the rest of it is fine.

Here is the code I am using to create the e-mail from excel:

Please Login or Register  to view this content.

[Norie]

Not short enough.

[Mousiefuzz]

Works perfectly. Thank you muchly!

(For the suggestion of adding ".Text" to the end of everything as you seem to have edited your answer)