1

I am using Word 2007 and have a form with "Filling in forms" protection. I have a formula field: { =Round(Price/0.5, 2) \# "$#,##0.00" } that shows like this: $ 100.00. The problem is how do I eliminate the space between the $ and the number? It should show like this: $100.00

Thanks for your help.

7
  • Have you tried changing the "0,00" to "0.00"?
    – Adam
    Feb 1, 2014 at 23:21
  • 1
    "$,0.00" would normally be enough to format a dollar amount how you want, assuming your decimal point character is "." And your thousands separator is ",". However, form field number formats can behave a bit differently from the ones in ordinary numeric fields, which is why I haven't posted this as an Answer
    – user181946
    Feb 2, 2014 at 7:59
  • @Adam Oops the "0,00" was a typo. Corrected the question. And yes I often do use the comma as a decimal separator depending on the destination for the document.
    – D_Bester
    Feb 2, 2014 at 15:42
  • @bibadia The format suggested by Word is "#,##0.00"
    – D_Bester
    Feb 2, 2014 at 15:57
  • @D_Bester: the format suggested when you select the format in a form field is as you say, and in fact it makes little difference in that case because leading # characters do not introduce extra space, but in other field types such as { = } fields, they do introduce extra space if the number has fewer characters than the pattern. So what I said was correct for { = }. With a FORMTEXT field you have to have at least one # at the beginning. Otherwise, the comma is treated as a literal rather than a thousands separator.
    – user181946
    Feb 2, 2014 at 16:34

1 Answer 1

1

Actually today when I tried again by recreating the field I didn't get the space. So I experimented with it a bit. I clicked on the number in the document and manually inserted a space between the $ and the number. Now I've got the space again and I can't fix it by changing the formula or the number format. So now I've just recreated the problem.

To remove the space I just click on the field in the document and manually delete the space. Done!

I guess I'm more familiar with how things work in Excel and this is very different.

1
  • Never thought to remove the space from the field result as it should be recreated from scratch every time the field is updated. Microsoft Word can be funny sometimes.
    – Adam
    Feb 2, 2014 at 22:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .