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 Apps
Answered

Big number format

(0) ShareShare
ReportReport
Posted on by

How to format a number for example "123456789" in 123 456 789 ? Same number with spaces ...


Thanks

Categories:
I have the same question (0)
  • Verified answer
    LaurensM Profile Picture
    12,516 Moderator on at

    Hi @ProtoSup,

     

    If the number is always 9 characters long, then you could opt for the approach below:

    //Text property of a label
    Text(123456789, "### ### ###")

     

    Should the length of the number be unknown, give the following a try:

    Concat(
     With(
     {
     wSplitArray: Split(
     12345678,
     ""
     )
     },
     ForAll(
     Sequence(CountRows(wSplitArray)),
     Index(
     wSplitArray,
     Value
     ).Value & If(
     Mod(
     Value,
     3
     ) = 0,
     " "
     )
     )
     ),
     Value
    )

     

    Replace all hardcoded references of the number with a reference to the number value.

     

    If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

    Thanks!

  • ProtoSup Profile Picture
    on at

    Ok thank you, in reality my number is 7 characters long, could you adapt your formula ? thanks again 

  • LaurensM Profile Picture
    12,516 Moderator on at

    Hey @ProtoSup,

     

    Given that the number is always 7 numbers long, we can adjust the easy formula:

    //This will show 1 234 567
    Text(1234567, "# ### ###")

     

    If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

    Thanks!

  • ProtoSup Profile Picture
    on at

    ok @LaurensM , I want to try your formula but I din't understand where I have to put this formula : 

    Concat(
     With(
     {
     wSplitArray: Split(
     12345678,
     ""
     )
     },
     ForAll(
     Sequence(CountRows(wSplitArray)),
     Index(
     wSplitArray,
     Value
     ).Value & If(
     Mod(
     Value,
     3
     ) = 0,
     " "
     )
     )
     ),
     Value
    )

     

  • LaurensM Profile Picture
    12,516 Moderator on at

    Hi @ProtoSup,

     

    That formula will return a formatted number as a Text value. It should be written in e.g. the Text property of a Label.

     

    I hope this helps!

  • ProtoSup Profile Picture
    on at

    Sorry, I did not see youy two formulas was 2 different way to resolv my problem... Thank you sir 

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
wolenberg_ Profile Picture

wolenberg_ 119 Super User 2026 Season 1

#2
WarrenBelz Profile Picture

WarrenBelz 107 Most Valuable Professional

#3
Haque Profile Picture

Haque 103

Last 30 days Overall leaderboard