Hi
I'm a relative beginner to creating Marco's in excel and I've managed to record a Macro that creates an e-mail and populates almost all of the data I require from the initial Excel sheet. My only issue is that Excel currently formulates one particular number to include the relevant commas and 2 decimel places but as my Macro is picking up the data directly from this cell the view of the number in my Outlook e-mail is does not include the required formatting (ie Excel displays 123,456.00 but Outlook then displays 123456). Is the Excel formatting something that can be transposed into the Outlook e-mail?

Many Thanks for any help available