ExcelBanter - can I format numbers in the yuan currency?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - can I format numbers in the yuan currency? (https://www.excelbanter.com/excel-discussion-misc-queries/189844-can-i-format-numbers-yuan-currency.html)

skc

can I format numbers in the yuan currency?

Gord Dibben

can I format numbers in the yuan currency?

This might help

Information on Chinese Currency

Renminbi: Chinese Currency is called Renminbi (RMB or CNY) means "People's
Currency"

Unit: Yuan, Jiao (some times called "Mao " ) and Fen. 1 Yuan = 10 Jiao (Mao); 1
Jiao = 10 Fen.

Excel has the CNY under Currency Format.

Gord Dibben MS Excel MVP

On Tue, 3 Jun 2008 12:04:00 -0700, skc wrote:

All times are GMT +1. The time now is 07:46 AM.