Number Format in Field (Word 2007)

Topic

New Reply

In our reports we often have to include fields that are formatted as currency with no decimal point (e.g., $12,000). The fields are entered through INSERT>QUICK PARTS>FIELD>FORMULA. The FORMULA dialogue box has a few pre-formatted numbers such as $#,###.00 but not $#,###. So each time we have to go into the dialogue box and add a dollar sign at the beginning of #,### (or delete the trailing zeros from $##,###.00).

To leave the number formatted with trailing zeros would imply an accuracy to the values that we have calculated that does not exist.

My question is whether there is any way of modifying this dialogue box to permanently add the format $#,### as an option.

I suppose I could use a macro and, where possible, we copy and paste pre-formatted fields within the document. But I’d prefer a more elegant (and permanent) solution.

The problem has existed, of course, in earlier versions of Word.

Any ideas?

Thanks.

Reply | Quote

Replies

The dialog is hard-coded as far as I know, so you can’t add. remove or modify the proposed formats.

Reply | Quote

Thanks, Hans. But how depressing!

The only solution I’ve found is to create a field with the currency formatting that I want and then assign it to a unique AutoCorrect character string. I can then insert a blank field with the correct formatting in any location in a document.

It works, but it’s hardly elegant.

Reply | Quote

Hi Peter,

If you’re desperate, you could replace the standard dialogue box with one of your own design – coded via vba. But that seems like a huge effort for very little return (ie complete overkill) to me!!

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

Thanks, Paul. Good suggestion.
One day I’ll get my head around VBA but in the meantime it’s a bit for me.

Reply | Quote