SharePoint - Beware of numeric calculated columns!

Help! - my numbers don't format correctly or they appear with loads of trailing numbers. If we encounter this problem, a likely cause is a bug that affects SharePoint calculated columns. This post examines this issue in more detail.