Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Dec 2007
    Location
    Sydney, New South Wales, Australia
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Number Format in Field (Word 2007)

    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.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Number Format in Field (Word 2007)

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

  3. #3
    Lounger
    Join Date
    Dec 2007
    Location
    Sydney, New South Wales, Australia
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number Format in Field (Word 2007)

    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.

  4. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Number Format in Field (Word 2007)

    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
    [MS MVP - Word]

  5. #5
    Lounger
    Join Date
    Dec 2007
    Location
    Sydney, New South Wales, Australia
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number Format in Field (Word 2007)

    Thanks, Paul. Good suggestion.
    One day I'll get my head around VBA but in the meantime it's a bit <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> for me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •