Try something similar to this custom number format:

#,##0 "Euros"

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"R" wrote in message
...
I have a table with 7 different currencies. I need to have a number and the
corresponding currency in a single field. I know it is possible in Excel
but
cannot find the right syntax. My table shows quantities multiplied by
rates
using different currencies. Like 10 * 5 Euros = 50 Euros, 7 * 10 Renminbi
=
70 Renminbi and so on.

The currency should not be in a different field but should actually define
the amount itself.