# Format data in dataset from tag history query

**URL:** <https://forum.inductiveautomation.com/t/format-data-in-dataset-from-tag-history-query/66780>\
**Category:** Ignition\
**Created:** [November 21, 2022, 9:34pm UTC](https://forum.inductiveautomation.com/t/format-data-in-dataset-from-tag-history-query/66780 "2022-11-21T21:34:25Z")\
**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 21, 2022, 10:17pm UTC](https://forum.inductiveautomation.com/t/format-data-in-dataset-from-tag-history-query/66780/2 "2022-11-21T22:17:53Z")

</div>

The answer is basically the same as your other question about HTML formatting of a dataset:

> [@CSV file from tag historian showing too many decimal points](https://forum.inductiveautomation.com/t/csv-file-from-tag-historian-showing-too-many-decimal-points/66661/2):
>
> 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). O…

---

_[View the full topic](https://forum.inductiveautomation.com/t/format-data-in-dataset-from-tag-history-query/66780)._