Format

Like (0) Share

Report

Posted on 30 Mar 2021 12:33:54 by Thomaw

101

Hello,
How to add 0 in front of a text string connected with Excel? For example I would like to have 00123456 instead of 123456 or 00012345 instead of 12345

thank you in advance

Categories:

General Questions

I have the same question (0)

All responses (5)

Answers (1)

Alex_Security 174 on 30 Mar 2021 at 12:51:00

Like (0)

Report

Re: Format

Hi @Thomaw,

can you provide more information? is this in a label, table or gallery? generally if using gallery, where you'd have thisitem.XXX, i'd use "000"&ThisItem.XXX as using the & sign allows you to append text strings and other values to other fields.

hope this helps, if it does feel free to mark it as a solution!

Was this reply helpful? Yes No
Ashwin7104 671 on 30 Mar 2021 at 13:09:07

Like (0)

Report

Re: Format

Hi @Thomaw ,

May be the below link could help you.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Add-leading-zeros-to-digits-using-Text/td-p/269238

Thanks.

Was this reply helpful? Yes No
RandyHayes 76,291 Super User 2024 Season 1 on 30 Mar 2021 at 13:23:36

Like (0)

Report

Re: Format

@Thomaw

If this is a numeric value and a fixed length you want, then simply use the Text function to provide your results.

Ex. Text(12345, "00000000") will produce - 00012345

I hope this is helpful for you.

Was this reply helpful? Yes No
Thomaw 101 on 30 Mar 2021 at 15:01:56

Like (0)

Report

Re: Format

Thank you all for your answers ... Great responsiveness of the community

@Alex_Security

I have thisetem.SLID so I guess it's gallery! The problem with your solution is that I need 8 characters total so in the case where 3x0 is missing it is good but if I am missing 2 or 1 zero I exceed my number of characters.
As in Excel, there would not be the possibility of custom formatting the 8-character value to be completed with 0s.

@RandyHayes

Valeur text 🙄

Was this reply helpful? Yes No
Verified answer

Thomaw 101 on 31 Mar 2021 at 09:41:25

Like (0)

Report

Re: Format

Salvation
It's good, thank you

Text(Value(ThisItem.ARTNO);"[$-fr-FR]00000000")

Was this reply helpful? Yes No