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

Notifications

Announcements

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 380 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 340

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 333 Super User 2025 Season 2

Last 30 days Overall leaderboard