Use a custom form of £#,,\M

--
__________________________________
HTH

Bob

"Jamal" wrote in message
...
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