IronSoftware
  • Products
    for .NET Java
    Create, read, and edit PDFs
    for .NET
    Image to text in 127 languages
    for .NET
    Read and write QR & Barcodes
    for .NET
    Edit Excel & CSV Files.
    No Office Interop required
    for .NET
    Extract structured data from websites
    5 for the Price of 2 All 5 .NET product licenses from $1498 Save 60% with Iron Suite Iron Suites - Donate $50
  • Open Source
    for .NET
    System.Drawing.Common Replacement
  • About Us
  • Contact Us

205 N. Michigan Ave. Chicago, IL 60611, USA +1 (312) 500-3060

Join Iron Slack

  • Home
  • Licensing
  • EULA
  • Support & Update Extensions
  • License Upgrades
  • Start 30-Day Trial
  • Features
  • Get Started
  • Code Examples
  • Tutorials
  • How-Tos
  • Troubleshooting
  • Product Updates
  • API Reference
  • Search
  • Free NuGet Download
IronXL - Excel Library for C# .NET IronXL - Excel Library for C# .NET
  • Home
  • Licensing
    • Licensing
    • EULA
    • Support & Update Extensions
    • License Upgrades
    • Start 30-Day Trial
  • Features
  • Docs
    • Search
    • Get Started
    • Code Examples
    • Tutorials
    • How-Tos
    • Troubleshooting
    • Product Updates
    • API Reference
    • Search
  • Search
  • Free NuGet Download Total downloads: 359,770
Message's icon
IronXL
Code Examples
  1. IronXL
  2. Code Examples
  3. Excel Number Format
IronXL
Free for development from NuGet

Install with NuGet nuget.org/packages/IronXL.Excel

PM > Install-Package IronXL.Excel

Explore the Docs

  • Get Started
  • Features
  • Code Examples
    • How to Read an Excel File in C#
    • Using C# to Create Excel Files in .NET
    • Use C# to Open & Write an Excel File
    • Compatibility
      • License Keys
      • Setup on macOS
      • Setup on AWS
      • Setup on Azure
      • Setup on Docker
      • Setup on Linux
      • Work with Excel in C# without Interop
      • Work with VB.NET Excel Files
      • Work with Excel on .NET MAUI
      • Read Excel Files in Blazor
    • Workbooks
      • Create Excel Documents in C#
      • Create an XLSX File
      • Parse Excel Files in C#
      • Read Excel File Example
      • Export to Excel in C#
      • Read XLSX File C#
      • Read a CSV in C#
      • Encrypt Workbook with Password
      • Read Excel Files in ASP.NET Web Apps
      • Write CSV in .NET
      • Open Excel Worksheets in C#
      • Convert a Data Table to CSV
      • Convert XLSX to CSV, JSON, XML
    • Worksheets
      • Freeze Panes
      • Encrypt Worksheet with Password
      • Add Rows & Columns in Excel C# Docs
      • add-rows-columns
      • Autosize Rows and Columns
      • Create Excel Charts in C#
    • Cell Ranges
      • Write Excel Values in .NET
      • Import Excel Data in C#
      • Merge and Unmerge Cells
      • Edit Excel Files in C#
    • Troubleshooting Guides
      • Apply a license key in IronXL
      • File Size Limits
    • Common Questions
      • IronXL - Security CVE
    • Changelog
  • API Reference
Create a new Excel File Load Excel Files without Interop Convert Spreadsheet File Types Convert Excel to HTML Edit Excel Metadata in C# Protect Excel Files Excel Print Setup Excel to SQL via System.Data.DataSet Excel to SQL and DataGrid via DataTable Update Excel Database Records Load Excel From SQL Database
Select Excel Range Sort Excel Ranges in C# Excel Formulas in C# Create Excel Chart Auto Adjust Rows & Columns Size Insert New Rows & Columns Repeat Excel Rows & Columns Freeze Panes in Excel Copy Excel Worksheets Group & Ungroup Rows & Columns
Aggregate Excel Functions Combine Excel Ranges Excel Conditional Formatting Excel Number Format Style Excel Cell Borders & Fonts

Excel Number Format

using IronXL;
using System;
using System.Linq;

// Load an existing WorkSheet
WorkBook workBook = WorkBook.Load("sample.xls");
WorkSheet workSheet = workBook.WorkSheets.First();

// Set data display format to cell
// The cell value will look like 12300%
workSheet["A2"].Value = 123;
workSheet["A2"].FormatString = "0.0%";

// The cell value will look like 123.0000
workSheet["A2"].First().FormatString = "0.0000";

// Set data display format to range
DateTime dateValue = new DateTime(2020, 1, 1, 12, 12, 12);
workSheet["A3"].Value = dateValue;
workSheet["A4"].First().Value = new DateTime(2022, 3, 3, 10, 10, 10);
workSheet["A5"].First().Value = new DateTime(2021, 2, 2, 11, 11, 11);

var range = workSheet["A3:A5"];

// The cell(A3) value will look like 1/1/2020 12:12:12 PM
range.FormatString = "MM/dd/yy h:mm:ss";

workBook.SaveAs("numberFormats.xls");
Imports IronXL
Imports System
Imports System.Linq

' Load an existing WorkSheet
Private workBook As WorkBook = WorkBook.Load("sample.xls")
Private workSheet As WorkSheet = workBook.WorkSheets.First()

' Set data display format to cell
' The cell value will look like 12300%
Private workSheet("A2").Value = 123
Private workSheet("A2").FormatString = "0.0%"

' The cell value will look like 123.0000
workSheet("A2").First().FormatString = "0.0000"

' Set data display format to range
Dim dateValue As New DateTime(2020, 1, 1, 12, 12, 12)
workSheet("A3").Value = dateValue
workSheet("A4").First().Value = New DateTime(2022, 3, 3, 10, 10, 10)
workSheet("A5").First().Value = New DateTime(2021, 2, 2, 11, 11, 11)

Dim range = workSheet("A3:A5")

' The cell(A3) value will look like 1/1/2020 12:12:12 PM
range.FormatString = "MM/dd/yy h:mm:ss"

workBook.SaveAs("numberFormats.xls")
Install-Package IronXL.Excel

Excel Number Format

We can use FormatString to format the display value of any Excel Cell or Range in C# with IronXL.

Read more about Excel number formats at https://www.ablebits.com/office-addins-blog/2016/07/07/custom-excel-number-format/

You can download a file project from this link.

Related Docs Links

Ready to get started? Version: 2023.2 just released

Start for Free Total downloads: 359,770
View Licenses >
Try IronXL for Free
Get Set Up in 5 Minutes
C# NuGet Library for PDF
Install with NuGet
Version: 2023.2
Install-Package IronXL.Excel
nuget.org/packages/IronXL.Excel/
  1. In Solution Explorer, right-click References, Manage NuGet Packages
  2. Select Browse and search "IronXL"
  3. Select the package and install
C# PDF DLL
Download DLL
Version: 2023.2
Download Now
Manually install into your project
  1. Download and unzip IronXL to a location such as ~/Libs within your Solution directory
  2. In Visual Studio Solution Explorer, right click References. Select Browse, "IronXL.dll"
Licenses from $749

Have a question? Get in touch with our development team.

Now that you’ve downloaded IronXL
Want to deploy IronXL to a live project for FREE?
Not ready to buy?

Want to deploy IronXL to a live project for FREE?

What’s included?
30 days of fully-functional product
Test and share in a live environment
No restrictions in production
Get your free 30-day Trial Key instantly.
Thank you.
If you'd like to speak to our licensing team:
Schedule a call
Have a question? Get in touch with our development team.
No credit card or account creation required
Your Trial License Key has been emailed to you.
Not ready to buy?
Thank you.
View your license options:
Thank you.
If you'd like to speak to our licensing team:
View Licensing
Schedule a call
Have a question? Get in touch with our development team.
Have a question? Get in touch with our development team.
Want to deploy IronXL to a live project for FREE?
Not ready to buy?

Want to deploy IronXL to a live project for FREE?

What’s included?
30 days of fully-functional product
Test and share in a live environment
No restrictions in production
Get your free 30-day Trial Key instantly.
Thank you.
If you'd like to speak to our licensing team:
Schedule a call
Have a question? Get in touch with our development team.
No credit card or account creation required
Your Trial License Key has been emailed to you.
Not ready to buy?
Download IronXL free to apply
your Trial Licenses Key
Thank you.
If you'd like to speak to our licensing team:
Install with NuGet View Licensing
Schedule a call
Licenses from $749. Have a question? Get in touch.
Have a question? Get in touch with our development team.
Free 30-Day Trial Key

Fully-functional product, get the key instantly

IronXL for .NET

The Excel API you need, without the Office Interop hassle.

Search

Documentation

  • Code Examples
  • API Reference
  • How-Tos
  • Features
  • Blog
  • Credits
  • Product Brochure

Tutorials

  • Get Started
  • Read an Excel File in C#
  • Create Excel Files in .NET

Licensing

  • Buy a License
  • Support Extensions
  • Resellers
  • License Keys
  • EULA

Try IronXL Free

  • Download on NuGet
  • Download DLL

  • 30-Day Trial License

When you need your PDF to look like HTML, fast.

Tesseract 5 OCR in the languages you need, We support 127+.

When you need to read, write, and style, QR & Barcodes, fast.

The Excel API you need, without the Office Interop hassle.

The power you need to scrape & output clean, structured data.

The complete .NET Suite for your office.

  • IRONSUITE
  • |
  • IRONPDF
  • IRONOCR
  • IRONBARCODE
  • IRONXL
  • IRONWEBSCRAPER
IronSoftware
205 N. Michigan Ave. Chicago, IL 60611 USA +1 (312) 500-3060
  • About Us
  • News
  • Careers
  • Contact Us
  • Join Iron Slack

Supporting Teamseas

Copyright © Iron Software LLC 2013-2023

  • Terms
  • Privacy

Thank you!

Your license key has been delivered to the email provided. Contact us

24-Hour Upgrade Offer:

Save 50% on a
Professional Upgrade

Go Professional to cover 10 developers
and unlimited projects.

hours

:

minutes

:

seconds

Upgrade to Professional

Upgrade

Professional

$600 USD

$299 USD


  • 10 developers
  • 10 locations
  • 10 projects
TODAY ONLY
Iron Suite

5 .NET Products for the Price of 2

IronPDF IronOCR IronXL IronBarcode IronWebscraper

Total Suite Value:

$7,192 USD

Upgrade price

TODAY
ONLY

$499 USD

After 24 Hrs

$1,098 USD