A strange number formatting

[NickP_DF]

Hello guys,

I need to convert a number into a 6-chars string keeping it on the right and filling the left side with blanks, so the number 12345 must be converted into ' 12345'...the number 1 into '     1'.

Is there a function to simply do it or have I to invent something never seen 'till today? 😁

Many thanks.

N.

[NickP_DF · Accepted solution]

Repeat(' ',6-Len(Text(num))) & num

N.

[Brett_Bleess]

Hey Nick, I am going to mark the post with the expression as the solution, as I think that is what you were say, please correct me if I am wrong in that assumption, thanks for posting it!  You should be able to mark it yourself, just FYI, after you do the post, you can still use the Accept as Solution button on it to mark it for future reference.

Regards,
Brett

[NickP_DF]

Hi Brett,

your assumption is right...I know the use of the "Accept as solution" button; I didn't use it because it seemed a bit strange  to me to post the question, the reply and auto-mark my solution as the right one!

Thank you so much.

N.

[Brett_Bleess]

Yeah, no worries, marking things lets folks know what actually worked, so do not hesitate to mark you own if you are explaining what you did to get things working...  Thanks for the follow-up, much appreciated!

Cheers,
Brett