What kind of "formatting" are you referring to, exactly?
At the moment, if I use the default choice available (such as number) when selecting format category from format tab in properties, then I can't type in "Not applicable" in that particular text field since an error message will appear. However, if i choose none, then when I type in numerical such as 1000, it will remain exactly as 1000. I'm hoping that it will auto format for me into 1,000.00.
You will need to write your own custom Format (and Validation) script to be able to do it.
I can create it for you, for a small fee. You can contact me privately (try6767 at gmail.com) to discuss it further, if you're interested.