Microsoft Excel supports wide range ofNumber Formats. One of these number formats isCurrency. If the cell value contains number, then you can apply currency format by specifying currency symbol and decimal places. Similarly, you can format Excel cell numbers to currency usingAspose.Cells for .NET with ease. In order to perform its operation, Aspose.Cells does not need Microsoft Excel or on any sort of Microsoft Office Automation, VBA (Visual Basic for Applications), VSTO (Visual Studio Tools for Office) etc.

Article Description

The purpose of this article is to explain how developers can format Excel cell numbers to currency in C#.NET. Alternatively, you can use any .NET Framework supported language e.g. VB.NET etc.

Supported Platforms

Aspose.Cells API supports all .NET frameworks e.g. .NET 2.0, .NET 3.5, .NET 4.0, .NET 7.0, .NET Core, .NET Standard 2.0, Xamarin etc. It is also available in other platforms e.g. Java, C++, Android, JavaScript, PHP etc. Besides,Aspose.Cells is available in Cloud as REST or RESTful APIs.

Licensing

Aspose.Cells is paid or commercial api, so it is not free or open source. Without license, it will work in evaluation mode with some limitations. If you want to test Aspose.Cells without evaluation version limitations, you can also request a30 Day Temporary License. For more information, please go throughLicensing.

Format Excel Cell Numbers to Currency using Microsoft Excel

You can format Excel cell numbers to currency using Microsoft Excel by performing these steps.

• Right Click the cell that contains some numeric value.
• ClickFormat Cells… from the context menu as shown in snapshot below.
• SelectCurrency fromNumber Category and pressOK.

Currency Custom Number Format Strings of Cell

You can use various types of currency custom number format strings to display currencies e.g. Dollar, Yuan, Pound, Euro etc. and many others.

Dollar

"$"#,##0.00

Yaun

[$¥-804]#,##0.00

Pound

[$£-809]#,##0.00

Euro

#,##0.00[$€-40B]

Format Excel Cell Numbers to Currency using Aspose.Cells

In the next few sections, we will learn how to use Aspose.Cells API to format Excel cell numbers to currency.

Sample Input Microsoft Excel Document

For demonstration, we will use the followingsample input Microsoft Excel document that contains some numbers in cells G3, G4, G5 and G6. We will apply currency format i.e. Dollar, Yuan, Pound, Euro on these cells respectively.

Sample Code

The following sample code formats Excel cells i.e. G3, G4, G5 and G6 with currency formats i.e. Dollar, Yuan, Pound, Euro respectively by performing these steps.

• Load theinput Excel file inside theAspose.Cells.Workbook object and access the first worksheet.
• Access first cell i.e. G3 and apply currency format using theStyle.Custom property.
• Repeat the second step for cell G4, G5 and G6 with further currency formats.
• Save theAspose.Cells.Workbook object in XLSX format. You can also save it to XLS or other Excel formats as per your needs.

Output Microsoft Excel XLSX by Aspose.Cells after applying Currency formats

The following snapshot shows theOutput Microsoft Excel XLSX by Aspose.Cells after applying currency formats on the cells G3, G4, G5 and G6. Similarly, you can apply all sorts of currency formats on Excel cells using Aspose.Cells API.