---
title: "Formatting data with leading zeros in Excel"
description: "Use parentheses around the function to force Excel to display leading zeros."
lang: en
languages:
  en: https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/formatting-data-with-leading-zeros-in-excel/index.md
  no: https://docs.vismasoftware.no/no/onestopreporting/create-templates/report-designer/creating-reports/formatting-data-with-leading-zeros-in-excel/index.md
lastmod: 2026-07-21
---

> Documentation index: https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/llms.txt


# Formatting data with leading zeros in Excel

Last modified July 21, 2026

> Use parentheses around the function to force Excel to display leading zeros.

If data generated in the report contains leading zeros (for example, Department numbered 000), Excel will only display a single 0.

However, you can properly display leading zeros by simply adding parenthesis before and after the OSR function in the formula bar. See the figure below.

![](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/formatting-data-with-leading-zeros-in-excel/img/en/Formatere-data-med-innledende-nuller-i-Excel_1.png)

![](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/formatting-data-with-leading-zeros-in-excel/img/en/Formatting-data-with-leading-zeros-in-Excel_2.png)

![](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/formatting-data-with-leading-zeros-in-excel/img/en/Formatere-data-med-innledende-nuller-i-Excel_3.png)


---

[View this page](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/formatting-data-with-leading-zeros-in-excel/)