Numbers digits

[Panoos64]

Hi to all of you,
I would like to use a VBA code so that, to arrange the numbers in column “C” up to 7 digits and placed the letter “I” and “-“ at left side. Therefore that in case that, the number doesn't contains 7 digits should place "0" so that to complete it. I present below an extract of original data and expected result. Thank you all in advance.

Original data

Expected result

 

[Panoos64]

Thank you Navic, the formula works perfect. Thank for your time spent for my project. Hv a nice day

 

[Panoos64]

Hi Rick, i tested once again and still have the same issue, but do not be so worry. I just say it for feedback purposes. Maybe is due to my office version and therefore that, i use office 2016. Thank you once again for your support. Hv a great day

 

[Rick Rothstein]

I am not sure why, but I thought you wanted a VBA solution. If a formula solution is acceptable, there is a much simpler one that you can use...

=TEXT(C2,"I-0000000")

 

[mohadin]

You are welcome
And thank you for the feedback
Be happy

 

[Panoos64]

Thank you Rick! it works by your formula. I thank you once again for your kindness to resolve my project. Hv a lovely day!