How can I format a group of cells to show £1,000,000 as £1 (or£1m). In other
words the number should be shown in millions format. Thanks for assistance.

Regards