# Report in Excel Truncating Zeros

**URL:** <https://forum.inductiveautomation.com/t/report-in-excel-truncating-zeros/38935>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [September 22, 2020, 1:41pm UTC](https://forum.inductiveautomation.com/t/report-in-excel-truncating-zeros/38935 "2020-09-22T13:41:20Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ryanjmclaughlin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryanjmclaughlin/32/4318_2.png) [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\
**Post date:** [September 22, 2020, 1:41pm UTC](https://forum.inductiveautomation.com/t/report-in-excel-truncating-zeros/38935/1 "2020-09-22T13:41:21Z")

</div>

I have a report which has a column that is treating the column as a number and truncating important leading zeros. In the DB it is stored as a varchar, but when dumped to an excel report the leading zeros are stripped. I tried numberFormat = 0 on the table in the report but that didn’t help.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/1/5119af0641f7b1a1db99bfafbe2813176166d185.png)

As a temp solution, I added a ’ at the front just to force it, but is there a way to properly fix this?