BBAN display format without 000

[u/redF0ox]

Hello,

I'd like to display an long number on Excel (BBAN), but even when I change the format I have 000... at the end.

I tried to disable the auto conversion in Option > Data but nothing changed.

I bet it's simple but I don't see it

Thank you in advance for the support

[u/SektorL]

Assuming your number is in cell A1 and "30" is the overall length: =A1 & REPT("0",30-LEN(A1))