# Spinner number format - show as thousands

**URL:** <https://forum.inductiveautomation.com/t/spinner-number-format-show-as-thousands/16852>\
**Category:** Ignition\
**Created:** [February 2, 2018, 5:00pm UTC](https://forum.inductiveautomation.com/t/spinner-number-format-show-as-thousands/16852 "2018-02-02T17:00:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mrogers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mrogers/32/4110_2.png) [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\
**Post date:** [February 2, 2018, 5:00pm UTC](https://forum.inductiveautomation.com/t/spinner-number-format-show-as-thousands/16852/1 "2018-02-02T17:00:36Z")

</div>

I think there are other places in Ignition where you can take a number like 1,000,000 or 1,000 and turn it into “1M” and “1K” or something, but the spinner doesn’t seem to be one of those places. I have a tag that stores a delay as milliseconds, but I’d like the spinner to just be in seconds. I tried and tried with no luck to get the numberformat to do what I want with no luck. I’ve tried to sort of convert manually to seconds and then to milliseconds to write, but I’m having issues with that as well.

Any ideas?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [February 2, 2018, 5:11pm UTC](https://forum.inductiveautomation.com/t/spinner-number-format-show-as-thousands/16852/2 "2018-02-02T17:11:05Z")

</div>

Use a [derived tag](https://docs.inductiveautomation.com/display/DOC79/Types+of+Tags#TypesofTags-DerivedTags) with the 1000:1 scaling, and point the spinner that one instead. (New in v7.9.2)

---

<div class="post-metadata">

**Author:** ![mrogers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mrogers/32/4110_2.png) [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\
**Post date:** [February 2, 2018, 5:13pm UTC](https://forum.inductiveautomation.com/t/spinner-number-format-show-as-thousands/16852/3 "2018-02-02T17:13:34Z")

</div>

Ah right, forgot about that, thanks!