Formatting numbers in a table (Word 2003)

Topic

New Reply

Does anyone know an easy way to format numbers in a table. For example, if numbers are entered as “-123”, I want them to show up as “(123)”. In Excel it is easy to change the format of numbers. But is there any easy way to do this in a Word table.

Reply | Quote

Replies

If you’re trying to format a field, yes. Use the Numeric Picture ( #) switch. For example, {= sales93 # “$#,##0.00;($ #,##0.00);$0”} displays a positive result for the bookmark “sales93” in a format such as “$1,245.65,” a negative result in parentheses, such as “($ 345.56),” and a zero result as “$0.” Is that what you’re looking for?

Reply | Quote