#1
|
|||
|
|||
Currency format in form
I work for an international company. We have a standard form that is required to be filled in for salary increment requests.
Currently this is a restricted form, where only specific fields can be edited. The salary field has a Number type, with Unlimited length and the format is $#,##0;($#,##0) This has the effect of converting whatever currency symbol is input into the dollar symbol. Is there a way of editing this so that a currency symbol is mandated, but that can be ANY currency symbol, not just the dollar? |
#2
|
||||
|
||||
No. You have to specify the currency symbol as part of the currency format. If you want the user to be able to specify the currency as well, you could delete the $ from the current field and provide a dropdown formfield with a list of currency symbols to choose from. If you have multiple such fields, but they always use the same currency, the selection need only be done in one place - you can use the 'calculate on exit' property and cross-referencing to replicate the symbol in the other locations.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Quote:
|
Tags |
currency, form field, format |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I create currency cells in a Word Table | DelHop | Word Tables | 13 | 09-09-2021 07:36 PM |
Conditional format for form drop-down list? | pmregan | Word | 1 | 09-19-2012 07:09 PM |
Automatically updating currency exchange rate? | Metamag | Excel | 2 | 09-07-2012 09:00 PM |
Formatting Cells for Currency and Accounting | Sparetyme | Excel | 1 | 07-11-2010 01:26 PM |
change currency $ to £ on excel invoice help | deanorx7 | Excel | 3 | 07-08-2008 04:40 AM |