# numberFormat() not display decimals **URL:** \ **Category:** Ignition\ **Tags:** ignition80, perspective\ **Created:** [December 9, 2021, 3:14pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944 "2021-12-09T15:14:09Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\ **Post date:** [December 9, 2021, 3:14pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/1 "2021-12-09T15:14:09Z")
Hi, I’m in Ignition 8.1.12. Expression below not works I don’t know why. Result must be 13.8. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/c/4c591c908ad96e7cf10a9b12ec64f289bba68b1e.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/4/3485063f424b1ff2de3f0c330a456e6a5daef1ff.png) ---
**Author:** ![SKA](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ska/32/29528_2.png) [@SKA](https://forum.inductiveautomation.com/u/SKA)\ **Post date:** [December 9, 2021, 3:15pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/2 "2021-12-09T15:15:46Z")
try toFloat() instead. [https://docs.inductiveautomation.com/display/DOC79/toFloat](https://docs.inductiveautomation.com/display/DOC79/toFloat) ---
**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\ **Post date:** [December 9, 2021, 3:21pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/3 "2021-12-09T15:21:28Z")
No changes. Result still 13 instead of 13.8 ---
**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Post date:** [December 9, 2021, 3:44pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/4 "2021-12-09T15:44:40Z")
Maybe `round` is what you are after, [https://docs.inductiveautomation.com/display/DOC81/round](https://docs.inductiveautomation.com/display/DOC81/round) ---
**Author:** ![kcollins](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kcollins/32/19646_2.png) [@kcollins](https://forum.inductiveautomation.com/u/kcollins)\ **Post date:** [December 9, 2021, 3:48pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/5 "2021-12-09T15:48:35Z")
I think you’ve got the right function, just the wrong format string. Try `#,##0.0`, e.g. ![2021-12-09 at 9.47 AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/f/5f068880d6e1b6adad826e80b0fafed63f8cb6b1.png) Reference: [Data Type Formatting Reference - Number Format](https://docs.inductiveautomation.com/display/DOC81/Data+Type+Formatting+Reference#DataTypeFormattingReference-NumberFormat) ---
**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\ **Post date:** [December 9, 2021, 3:55pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/6 "2021-12-09T15:55:44Z")
With “#,##0.0” result is 13.0. Curious ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/1/c1e5294160273195de218eda119b25f09276f42f.png) ---
**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\ **Post date:** [December 9, 2021, 3:58pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/7 "2021-12-09T15:58:25Z")
🤯 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/a/da59e43fb4f227352be3b4f50bc457b15c76fe62.png) ---
**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\ **Post date:** [December 9, 2021, 4:01pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/8 "2021-12-09T16:01:44Z")
It works in python script. Is there a solution in python to do same format like “#,##0.##” ? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/2/c254cc3b83da53502c2fa163349fbc1f826c34b3.png) ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [December 9, 2021, 4:01pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/9 "2021-12-09T16:01:45Z")
What if you just return `{value}` ? ---
**Author:** ![kcollins](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kcollins/32/19646_2.png) [@kcollins](https://forum.inductiveautomation.com/u/kcollins)\ **Post date:** [December 9, 2021, 4:01pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/10 "2021-12-09T16:01:47Z")
What are the settings under Project-\>Project Properties and Perspective-\>General? Do you have a Project Locale specified? ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [December 9, 2021, 4:05pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/11 "2021-12-09T16:05:14Z")
You could use ```python "{n:1f}.format(n=value)" ``` What is exactly the output format you want ? ---
**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\ **Post date:** [December 9, 2021, 4:05pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/12 "2021-12-09T16:05:47Z")
Project Locale is Browser. With just {value} output is the same as input var type is string. ---
**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:** [December 9, 2021, 4:10pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/13 "2021-12-09T16:10:16Z")
I’m confused. Does the bare `numberFormat({value})` ( **without** `toFloat`) not work for you? What’s the actual type of this value (try the `typeOf` expression function)? It sure looks like a floating point to start. ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [December 9, 2021, 4:10pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/14 "2021-12-09T16:10:27Z")
Wait, what ? Is your input property a string, or is the output a string ? ---
**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\ **Post date:** [December 9, 2021, 4:14pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/15 "2021-12-09T16:14:12Z")
input is a string, and the result is displayed in a label text so output should be a string. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/9/b9c4fe7dac58e961ac5f13a486dad90b62ac8764.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/4/34c724cca3f52c572ef7ce0d4219ea4a74502c1d.png) ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [December 9, 2021, 4:30pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/16 "2021-12-09T16:30:13Z")
Did you try a Format transform? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/5/d5a743119da159dc353e66afe0a11999de818ace.png) ---
**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\ **Post date:** [December 9, 2021, 4:41pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/17 "2021-12-09T16:41:43Z")
Same problem. 😭 ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [December 9, 2021, 4:48pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/18 "2021-12-09T16:48:39Z")
Can you try doing it on another input and see if you get the same results ? Maybe make a custom prop and bind it to `toString(13.81235124)`, then try applying the same process to this one. ---
**Author:** ![kyle.demerath](https://avatars.discourse-cdn.com/v4/letter/k/5e9695/32.png) [@kyle.demerath](https://forum.inductiveautomation.com/u/kyle.demerath)\ **Post date:** [January 11, 2022, 5:46pm UTC](https://forum.inductiveautomation.com/t/numberformat-not-display-decimals/53944/19 "2022-01-11T17:46:33Z")
Is numberFormat supposed to obey the locale? Yours appears to have put a , in instead of a . but I can’t get it to do that for me like the Format Transform can. Unfortunately with the Format Transform I can’t have dynamically set significant figures.