I don't know what the \D (capital D does).

"(\D+(-)?\d+)"

1) \d+ the backslash d say take one digit, the plus says take all
didgits folowing the first digit (digit is 0 to 9)

2) ? says match any character before the string of digits 0 to 9.

3) "(\d+|([-+]\d+))" the first part is the same as the \d+ above. I
added the pipe to have an Or'd conditions. Te square brackets say to
match either character the plus sign or the minus sign.


I think you have a space in front of the minus sign. Then you need
this

"(\d+|([-+]\b\d+))"

You could also try this which will accept either a space between the
plus and minus sign of no space.

"(\d+|([-+]\b\d+))|([-+]\d+)"


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=168082

Microsoft Office Help