i have some templates i am modifying. the data for the templates come from
a database using xml.

its in the following format

{MERGEFIELD "Client Phone Number:" "repeater=1" "xPath=
Client\Forms\ClientPhoneNo" "TableName=" "mask=" \* MERGEFORMAT}

i want to format the darn thing to (###)###-####
i want make sure it is numeric if its not then i don t want the above
formatting and just add as it is.

please help

thanks

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"raj" wrote in message
...
i have some templates i am modifying. the data for the templates come from
a database using xml.

its in the following format

{MERGEFIELD "Client Phone Number:" "repeater=1" "xPath=
Client\Forms\ClientPhoneNo" "TableName=" "mask=" \* MERGEFORMAT}

i want to format the darn thing to (###)###-####
i want make sure it is numeric if its not then i don t want the above
formatting and just add as it is.

please help

thanks