Ifdecimalsis negative,numberwill be rounded to the left of the decimal point.Decimalsis optional and defaults to 2.
Theno_commasargument is a Boolean that controls whether commas will be added to the result.No_commasis optional and defaults to FALSE.
Topreventcommas, setno_commasto TRUE.
Video:How to use number formatting.
The example below shows how the output from thePI functioncan be trimmed by FIXED:
FIXED vs.
TEXT
The FIXED function is a specialized function to apply Number formatting only.
TheTEXT functionis a generalized function that does the same thing in a more flexible way.
in a text string with the number format of your choice.
DOLLAR Function
The Excel DOLLAR function converts a number to text using the Currency number format.
The TEXT function can do the same thing, and is much more versatile.
