For example you have a table with three columns and at one of them you want to apply Percentage Format. And you can also apply Text Format to them. In addition, there are tables in dashboards. Next, on the opening Text Format window you choose Percentage Format and set percentage symbol: To do this you should choose Argument Format and click on the edge button in properties: At an argument axis (X) chart you have axis values as prime numbers and you want to turn them into percentages: And let`s look at applying Text Format to the argument axis. Then at the appeared Text Format form choose Number Format and activate Use Abbreviation property:Īnd you get a chart with formatted values: Choose Value Format and click on the edge button: You can find 2 properties there: Argument Format and Value Format. For example at your chart thousands are displayed in the standard way: "1,800" "1,600", and you want to shorten them and give them a different look, for example like this: "1.8K" "1.6K". Things are a little bit different with charts. Next, go to the Home tab, then Text Format and choose Currency Format: So let`s consider its applying to indicators. Next, you should make the template you need: +(#) # - # - #, then the numbers from the text appear instead of hashes and you get "+1 (23) 45 - 67 - 89" from "123456789" text. In this format you can find (#) # - # format mask:Ĭhoose it and you will be able to format a phone number as you need. To do this you should highlight the text component and choose Custom Format. For example you need to display a phone number with a code, brackets, dash and so on. In addition to the above you can format a phone number. To do this you should highlight the text component, then choose Time Format and P.M. For example you typed text "14:00", but you decided to change it to "2:00 PM" for your American colleagues. To do it you should type in your text the date you are used to, then highlight the text component, choose Date Format and the date format you need:Ī few more words about changing time format. Suppose you have the same situation - you are in Russia, sitting at a computer, where date is put firstly, then month and year and you need to send a report to your colleagues in the USA, where month is put first and only then date and year. Next, you should set necessary number of fractional signs in format properties:Īll of the above formats – Currency, Percentage, Number have the following properties: the number of decimal places, group separator, group size, positive template, negative template and currency template.Īlso you can change date format. To do it you should highlight the text component and choose Number Format: For example you need to apply a format with division into groups and adding a fractional part for "1500" text. Next, you should set percentage symbol in format properties:īesides, with the help of Number Format you can change number`s format. Remember, that the percentage Format multiplies a value by 100: To do it you should highlight the text component and choose Percentage Format. For example you have "87" symbols and you need to turn them into "87%". For example you just type "1500" text, highlight the text component and then choose Currency format: With the help of this format you can type currency symbol, in your case it`s a dollar symbol "$". This format is applied to text, if you need to use currency designation. To do it you should choose Currency Format: Also you want to type percentages and decimal numbers in this report. This button allows to set additional format properties:įor example you want to type a dollar symbol "$", but you use a computer with Russian locale and you have to send a financial report to your colleagues in the USA, using symbol "$". There is a set of standard templates, their settings depend on the localization of operating system, and a form call-button of Text Format in the Text Format panel: With the help of it you can display your text in different variants, such as money, percents, decimal numbers and phone numbers.Īll settings of the text format you can find in Home tab in Text Format panel: Text Format is a functionality that allows to apply various templates to text.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |