Mail merge in Office 2007

[AirWolf]

Hi all

I have a spreadsheet with some info which is mail merged with a word document for easy printing using the same basic format. Some of the data in the spreadsheet is in Rands (either currency of accounting format). In Office 2000 the data that appears in the word document includes the "R" for the Rand amounts and the 2 decimals for the cents. In office 2007 however the "R" does not appear in the word document and it doesn't hold 2 decimal places eg R999.50 appears as 999.5

How do I change this?

 

[mh348]

In Excel Highlight the Cells, Select Format Cells, & and choose Currency.

 

[AirWolf]

In Excel Highlight the Cells, Select Format Cells, & and choose Currency.

I did try both currency and accounting formats and it still doesn't work in Office 2007.