# Issue with Days Remaining Column Showing Decimal Values in PDF Output

**URL:** https://community.glideapps.com/t/issue-with-days-remaining-column-showing-decimal-values-in-pdf-output/78180
**Category:** Ask for Help
**Created:** [November 25, 2024, 9:32am UTC](https://community.glideapps.com/t/issue-with-days-remaining-column-showing-decimal-values-in-pdf-output/78180 "2024-11-25T09:32:16Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![scotfield123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scotfield123/32/62356_2.png) [@scotfield123](https://community.glideapps.com/u/scotfield123)
#### Post date: [November 25, 2024, 9:32am UTC](https://community.glideapps.com/t/issue-with-days-remaining-column-showing-decimal-values-in-pdf-output/78180/1 "2024-11-25T09:32:16Z")

</div>

I’m experiencing an issue with a column in my Glide table that calculates “days remaining.” The values in the column usually appear as something like “127 days remaining,” which is what I want. However, if I double-click on a cell in the column, the value changes to something like “127.2343732,” which looks like the raw underlying data.

The bigger problem is that when I generate a PDF or share the data, it shows the decimal value (e.g., “127.2343732”) instead of the cleaner “127 days remaining” format.

Is there a way to make sure the displayed format (“127 days remaining”) is locked in and also shown when exporting or printing?

Thanks for your help!

 ![Screenshot 2024-11-25 092629](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/7/87a908194fb17fcb425ae36a8046056059fe55d9.png)  
 ![Screenshot 2024-11-25 092638](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/6/a60b8ca77f69d93803a40cafc79f7798ff8e9ffe.png)

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [November 25, 2024, 10:14am UTC](https://community.glideapps.com/t/issue-with-days-remaining-column-showing-decimal-values-in-pdf-output/78180/2 "2024-11-25T10:14:26Z")

</div>

How are you calculating the days remaining?

I would use the following in a math column and set the precision to zero decimals:

```auto
Trunc(Date-Now)

```

- where `Now` is the current date/time, and
- `Date` is the date of interest