web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Decimal representation
Power Apps
Unanswered

Decimal representation

(0) ShareShare
ReportReport
Posted on by 8
Hello,

I'm encountering a problem with my decimal representation. I've created an app in Power Apps and have a gallery displaying a table from OneDrive. However, when I load the numbers into my DataCard, the format of the number shows with a period "0.0". Yet, in my Excel list, it appears with a comma ",". Interestingly, on another device, it shows with a period both in my Excel list and in Power Apps.

Furthermore, when I change the number in the DataCard in Power Apps to "0.9", it saves in my Excel list as "99". It seems that the decimal point isn't being preserved correctly.

All devices are set to the same language. Can anyone assist me, please?

Categories:
I have the same question (0)
  • timl Profile Picture
    36,682 Super User 2026 Season 1 on at

    Hi @Clausii 

    >>the format of the number shows with a period "0.0".

    This is almost definitely due to language settings. How are you accessing Power Apps? If it's through a browser, it's the language setting of the browser that's important, rather than the language of device. Can you confirm the language of your browser?

  • Clausii Profile Picture
    8 on at

    hi @timl 

    All of my language settings are set to German, both in Power Apps and in the browser, as well as in Excel, which I use solely in the browser. It's odd that when I have "." in Excel and Power Apps on another system, and then input the numerical value 0.90 in Power Apps, I still get only 99 in my Excel list, meaning it doesn't recognize the period

     

  • timl Profile Picture
    36,682 Super User 2026 Season 1 on at

    Hi @Clausii 

    So just to clarify, German appears at the very top of the language list like so?

     

    timl_0-1706207231087.png

     

  • Clausii Profile Picture
    8 on at

    Yeah all my settings are on German 

  • Clausii Profile Picture
    8 on at

    On the office.com site my language is English but when I go to the settings it is in German. 

  • Clausii Profile Picture
    8 on at

    I could find a way to change it 

    Text(Substitute(Parent.Default; "."; ","))

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 85

#2
WarrenBelz Profile Picture

WarrenBelz 76 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard