Where Is Chris Davison's MATCH Question?

[Aladin Akyurek]

Chris,

Did you delete the question while I was busy composing a lengthy answer?

If so, Why?



Aladin
This message was edited by Aladin Akyurek on 2002-03-17 16:14

 

[proficient]

Aladin,

I have asked a question related REPT in other post but didn't get reply (Actually got a reply but need more detailed answer) the question is that when I type any numeric in A1 and type this below formula in B1 to get the ZEROs I want.
=REPT("O",A1), at this stage formula works OK but I need to add another thing in it that is "after every TEN (0) Zeros I need a DASH (-) see below for easy ref
0000000000-0000000000-0000000000-
if I type 33 in A1, B1 will show somthing like that
0000000000-0000000000-0000000000-000

Hope you understand what actually I wanted to know...
Waiting for your MASTER PIECE