Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a document with text form fields that have already been filled in with values. They are formatted as type "number" with the number format "0".

I want to change all the fields with the number format "0" to be formatted as "#,##0". However, when I try to click one and change this (in "Form Field Options"), it resets any text in the field to its default value.

Is there any way I can change the field's number format without removing the value that has been manually entered in the field?

share|improve this question

I don't think so. Changing the format resets the field to avoid invalid data entry, because it's easier from Word's point of view.

I suppose you could automate the process with a macro that iterates through all the fields, copies the existing value to a variable, changes the format and copies the value back, but that's quite a lot of work, and it may be simpler to just do this manually.

share|improve this answer
Thanks, I figured as much. The reason I asked is I need to do this for a large number of fields so the macro idea actually sounds good. – user130757 Apr 28 '12 at 4:07

You must log in to answer this question.