F
Frank H
Can anybody assist ?
I wish to format a whole number in a text box so that
there is a dash (minus sign) every third digit from the
right.
eg 123 formats as 123
1234 as 1-234
12345 as 12-345
123456 as 123-456
1234567 as 1-234-567 and so on
I have tried combinations of # & 0 & - chars but cannot
get it to work
TIA
Frank
I wish to format a whole number in a text box so that
there is a dash (minus sign) every third digit from the
right.
eg 123 formats as 123
1234 as 1-234
12345 as 12-345
123456 as 123-456
1234567 as 1-234-567 and so on
I have tried combinations of # & 0 & - chars but cannot
get it to work
TIA
Frank