Insert a customized currency into a number!

marwan1

Board Regular
Joined
Mar 2, 2011
Messages
145
Hi every one,

Say I want to create one of the currencies that not available in the excel built-in currencies and isert it into the cell with the number?
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Weaver

Well-known Member
Joined
Sep 10, 2008
Messages
5,196
In the 'format cells' wizard, click the 'number' tab, choose 'custom' from the list on the left and in the 'type' textbox, type or paste the following:

#,##0.00 "pesos"
 

Watch MrExcel Video

Forum statistics

Threads
1,109,549
Messages
5,529,468
Members
409,883
Latest member
asharris90
Top