web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps format number with dec...

Power Apps

Unanswered

format number with decimal

(0) Share

Report

Report

Posted on by vincenzo1984

43

i have the follow number on db and i display in gallery, and when i put in text label i lose decimal and poi separator.

ex

1.000 on galllery became 1000 but i want 1.000

1.366 on galllery became 1366 but i want 1.366

thanks in advance

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @vincenzos1984 ,

You can use like below.
Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@vincenzos1984

This is from the documentation.

Text( 1234.59, "####.#" ) "1234.6" Formats the number with one decimal place. Text( 8.9, "#.000" ) "8.900" Pads the decimal portion of the number with trailing zeros, if needed. Text( 0.631, "0.#" ) "0.6" Pads the whole portion of the number with leading zeros, if needed. Text( 12, "#.0#" ) "12.0" Pads the decimal portion of the number with zeros for one decimal place, Text(1234.568,"#.0#") "1234.57" and includes a second decimal place if supplied. Text( 12000, "$ #,###" ) "$ 12,000" Places a thousands separator every three digits, Text( 1200000, "$ #,###" ) "$ 1,200,000" and includes a currency symbol.

Join the conversation