Forum Discussion
Custom Format to Thousand
Hi all,
I have to format the number 445,074,667 to 445,007
how do I achieve this?
thanks!
Use #,##0, as your custom number format. Go to the Modeling tab to set this. Select the field, then in the custom format section type the above string. It must have the trailing comma Anonymous
Custom number formatting is very similar to Excel's custom formats. All of the format strings can be found here.
1 Reply
Use #,##0, as your custom number format. Go to the Modeling tab to set this. Select the field, then in the custom format section type the above string. It must have the trailing comma Anonymous
Custom number formatting is very similar to Excel's custom formats. All of the format strings can be found here.