Excel: FIXED(number,decimals,no_commas)
FIXED function returns a text representation of a number rounded to a specified number of decimal places.
We can obtain text representation of a number such as ID given by number, then we can data operation such as consolidate some datas by ID.
e.g.
convert 100(number) to 100(text)
FIXED(100,0,TRUE)