Knowledge Drop

Pound Name Value Format £

  • 7 July 2021
  • 0 replies
  • 335 views

Last tested: Aug 20, 2019
 

This format will apply a pound format to values without decimals where name_value_format is an option:

 

[$£-en-GB]#,##0

 

Result:

Screenshot 2019-08-20 at 11.22.00.png

This following format will give you the decimals up to the number of zeros you add after the decimal, this example will give up to two decimal places:

 

[$£-en-GB]#,##0.00

 

Result:

Screenshot 2019-08-20 at 11.22.07.png

If you want to show in millions with and "M" suffixed at the end you will need to add two commas after the 0 values you have used. Every comma will bring the decimal place up 3 points so we need two for a million, but you could use one for thousands:

[$£-en-GB]#,##0.00,,"M"

 

Result:

Screenshot 2019-08-20 at 11.26.18.png

I used excel to find this value for £. If you create a tile with a number in it> click format cells> choose the format you want from the options they have > instead of clicking okay click custom on the left and then copy the format that shows there.

 

This content is subject to limited support.                

 

 


0 replies

Be the first to reply!

Reply