Hi,
I would like the numbers to show as #,### but not sure where exactly to put it in my formula for "text":
"The most meals packed are in: " & First(Sort(FullData; TotalMeals; Descending)).Location2 & " where " & First(Sort(FullData; TotalMeals; Descending)).TotalMeals & " have been packed!"
Total Meals is the numbers i want to see formatted.
Thanks,
Su
...& Text(First(Sort(FullData; TotalMeals; Descending)).TotalMeals,"#,###") & " have been packed!"
Hi @Drrickryp , thanks for the response but it is giving me error in the formula.