Previous topicNext topic
Help > 开发指南 > Excel > API > 示例 > 设置单元格格式 >
如何：指定单元格内容的数字或日期格式

电子表格文档 API 使用 Microsoft Excel 数字格式将单元格编号显示为百分比、小数、货币、会计和日期/时间值。若要将数字格式应用于单元格或单元格区域，请为 NumberFormat 或 NumberFormatLocal 属性分配适当的格式代码。本主题包含一些示例，这些示例演示如何使用标准和自定义数字格式来设置数值单元格值的格式。

日期和时间格式

此示例演示如何为单元格中的日期和时间值指定不同的显示格式。

Vb.Net
worksheet.Range("A1:F1").Formula = "= Now()"

' Apply different date display formats.
worksheet.Cells("A1").NumberFormat = "m/d/yy"

worksheet.Cells("B1").NumberFormat = "d-mmm-yy"

worksheet.Cells("C1").NumberFormat = "dddd"

' Apply different time display formats.
worksheet.Cells("D1").NumberFormat = "m/d/yy h:mm"

worksheet.Cells("E1").NumberFormat = "h:mm AM/PM"

worksheet.Cells("F1").NumberFormat = "h:mm:ss"

C#
worksheet.Range["A1:F1"].Formula = "= Now()";

// Apply different date display formats.
worksheet.Cells["A1"].NumberFormat = "m/d/yy";

worksheet.Cells["B1"].NumberFormat = "d-mmm-yy";

worksheet.Cells["C1"].NumberFormat = "dddd";

// Apply different time display formats.
worksheet.Cells["D1"].NumberFormat = "m/d/yy h:mm";

worksheet.Cells["E1"].NumberFormat = "h:mm AM/PM";

worksheet.Cells["F1"].NumberFormat = "h:mm:ss";

下图显示了用于在单元格中显示日期和时间值的不同格式（工作簿在 Microsoft® Excel® 中打开）。

数字格式

本示例演示如何使用不同的数字格式在单元格中显示数值。

Vb.Net
' Display 111 as 111.
worksheet.Cells("A1").Value = 111
worksheet.Cells("A1").NumberFormat = "#####"

' Display 222 as 00222.
worksheet.Cells("B1").Value = 222
worksheet.Cells("B1").NumberFormat = "00000"

' Display 12345678 as 12,345,678.
worksheet.Cells("C1").Value = 12345678
worksheet.Cells("C1").NumberFormat = "#,#"

' Display .126 as 0.13.
worksheet.Cells("D1").Value =.126
worksheet.Cells("D1").NumberFormat = "0.##"

' Display 74.4 as 74.400.
worksheet.Cells("E1").Value = 74.4
worksheet.Cells("E1").NumberFormat = "##.000"

' Display 1.6 as 160.0%.
worksheet.Cells("F1").Value = 1.6
worksheet.Cells("F1").NumberFormat = "0.0%"

' Display 4321 as $4,321.00.
worksheet.Cells("G1").Value = 4321
worksheet.Cells("G1").NumberFormat = "$#,##0.00"

' Display 8.75 as 8 3/4.
worksheet.Cells("H1").Value = 8.75
worksheet.Cells("H1").NumberFormat = "# ?/?"

C#
// Display 111 as 111.
worksheet.Cells["A1"].Value = 111;
worksheet.Cells["A1"].NumberFormat = "#####";

// Display 222 as 00222.
worksheet.Cells["B1"].Value = 222;
worksheet.Cells["B1"].NumberFormat = "00000";

// Display 12345678 as 12,345,678.
worksheet.Cells["C1"].Value = 12345678;
worksheet.Cells["C1"].NumberFormat = "#,#";

// Display .126 as 0.13.
worksheet.Cells["D1"].Value = .126;
worksheet.Cells["D1"].NumberFormat = "0.##";

// Display 74.4 as 74.400.
worksheet.Cells["E1"].Value = 74.4;
worksheet.Cells["E1"].NumberFormat = "##.000";

// Display 1.6 as 160.0%.
worksheet.Cells["F1"].Value = 1.6;
worksheet.Cells["F1"].NumberFormat = "0.0%";

// Display 4321 as $4,321.00.
worksheet.Cells["G1"].Value = 4321;
worksheet.Cells["G1"].NumberFormat = "$#,##0.00";

// Display 8.75 as 8 3/4.
worksheet.Cells["H1"].Value = 8.75;
worksheet.Cells["H1"].NumberFormat = "# ?/?";

下图显示了用于在单元格中显示数字的不同格式（工作簿在 Microsoft® Excel® 中打开）。

自定义数字格式

此示例演示如何创建自定义数字格式，该格式使用不同的格式和颜色来显示正数、负数、零值和文本。代码节用分号分隔，并按以下顺序使用：

<正面>;<负面>;<零>;<正文>

有关如何创建自定义数字格式的详细信息，请参阅以下主题： 数字格式代码 。

Vb.Net
' Set cell values.
worksheet("A2:B2").Value = -15.50
worksheet("A3:B3").Value = 555
worksheet("A4:B4").Value = 0
worksheet("A5:B5").Value = "Name"

' Apply custom number format.
worksheet("B2:B5").NumberFormat = "[Green]#.00;[Red]#.00;[Blue]0.00;[Cyan]""product: ""@"

C#
// Set cell values.
worksheet["A2:B2"].Value = -15.50;
worksheet["A3:B3"].Value = 555;
worksheet["A4:B4"].Value = 0;
worksheet["A5:B5"].Value = "Name";

// Apply custom number format.
worksheet["B2:B5"].NumberFormat = "[Green]#.00;[Red]#.00;[Blue]0.00;[Cyan]\"product: \"@";

下图显示了应用自定义数字格式（工作簿在 Microsoft® Excel® 中打开）时如何在单元格中显示不同的值。