It would be nice if we could add a custom number formats/notations to the list of notation formats in the drop down menu for record formats.
e.g. someone requested to use dots instead of dashes in a date notation, but if you set the record as number>date you can only use the predefined formats which use the system setting for separators. However as I work internationally I run into the issue of dealing with multiple date notations, so I simply use a text field to avoid reformatting issues based on system settings.
The same applies to decimal separators, sometimes I have to use a comma and sometimes a dot. For thousands separators it can be a space as well instead of a dot or comma.
Issues like this could be solved by allowing for custom number formats to be added to the list of available notation formats.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Art V
It would be nice if we could add a custom number formats/notations to the list of notation formats in the drop down menu for record formats.
e.g. someone requested to use dots instead of dashes in a date notation, but if you set the record as number>date you can only use the predefined formats which use the system setting for separators. However as I work internationally I run into the issue of dealing with multiple date notations, so I simply use a text field to avoid reformatting issues based on system settings.
The same applies to decimal separators, sometimes I have to use a comma and sometimes a dot. For thousands separators it can be a space as well instead of a dot or comma.
Issues like this could be solved by allowing for custom number formats to be added to the list of available notation formats.
Edited by Art VLink to comment
0 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.