Number format
 

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

Number format
 

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

Number format
 

Thanks for you answer. Is it possible to show 500,000 as £0.5m by changing
this format in anyway. Thanks.

Jamal

"Bob Phillips" wrote:

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

Number format
 

Yeah, try this

£#0.0,,\M

--
__________________________________
HTH

Bob

"Jamal" wrote in message
...

Thanks for you answer. Is it possible to show 500,000 as £0.5m by changing
this format in anyway. Thanks.

Jamal

"Bob Phillips" wrote:

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