Customized Number Format Required.

Dear Users,

I want to know if someone could get me "42101-7616130-9" <-- this data without quotes which is without any spaces to "4.2..1.0.1..-..7.6..1.6.1..3.0..-.9" without quotes either but please consider dots (.) as spaces as 1 dot equals to 1 space that would be as "4 2 1 0 1 - 7 6 1 6 1 3 0 - 9" I would really be very thankful for this kindness.

Please help.

that mean there is no way out? I want to show this number just as I have shown earlier I don't want to use it as an equation or for any calculation purposes.

Originally Posted by JosephP

you could do it with code or a formula just not a number format
=TEXT(--SUBSTITUTE(A1,"-",""),"0 0 0 0 0 - 0 0 0 0 0 0 0 - 0")
for instance

Sir I have tried it but it doesn't show spaces between them suppose:
a1 b2
42101-7616130-9 42101-7616130-9 <-- same result no spaces ..

could you please be more brief sir? Please just paste the formula here supposing A1 is the 42101-7616130-9 what should I put in b1 to get the result as mentioned above? in first post?

thank you so much sir ! by your favour and guidance it worked :D thank you thank you thank you !!!!!!!!!!! Umah !!

thank you so much sir ! by your favour and guidance it worked :D thank you thank you thank you !!!!!!!!!!! Umah !!
if O4 is 4210176161309 then =TEXT($O4,"# # # # # - # # # # # # # - #") the result would be as desired:
4 2 1 0 1 - 7 6 1 6 1 3 0 - 9 thank you once again Sir ! your really kind.