# CSV file from tag historian showing too many decimal points

**URL:** <https://forum.inductiveautomation.com/t/csv-file-from-tag-historian-showing-too-many-decimal-points/66661>\
**Category:** Ignition\
**Created:** [November 17, 2022, 11:14pm UTC](https://forum.inductiveautomation.com/t/csv-file-from-tag-historian-showing-too-many-decimal-points/66661 "2022-11-17T23:14:07Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [November 17, 2022, 11:40pm UTC](https://forum.inductiveautomation.com/t/csv-file-from-tag-historian-showing-too-many-decimal-points/66661/2 "2022-11-17T23:40:01Z")

</div>

That long string of digits is Java attempting to be polite and give you an as-exact-as-possible representation of the value as it can.  
If you want to provide explicit formatting, you must do that yourself (by looping over the dataset and changing each float value to a string using your own formatting operation. `system.dataset.toHTML` doesn't offer you control over this.  
You could do this with `system.dataset.addColumn` and `system.dataset.filterColumn` (to remove the now duplicate value columns). Or you could install [Ignition Extensions](https://forum.inductiveautomation.com/t/ignition-extensions-convenience-utilities-for-advanced-users/64615) and use `system.dataset.map`.

Or, you could write a script that does what `system.dataset.datasetToHTML` does, but better; it's not a super complicated bit of scripting.

---

_[View the full topic](https://forum.inductiveautomation.com/t/csv-file-from-tag-historian-showing-too-many-decimal-points/66661)._
