Hi there, can anyone help me?

If I've got a figure in a spreadsheet, say £5,678,123 and I want this figure
to be shown as £5.68 (as in £5.68 million), is there an easy way of entering
a formula to do this automatically? The figures don't have to be numeric,
they can be as text.

Many thanks.

I use the following for $...just sub the pound sign.

$#,##0,

Brian

--
Message posted via http://www.officekb.com

Sorry..I forgot to tell you to go to format, custom, then add the format I
outlined.

Brian

--
Message posted via http://www.officekb.com

Do you simply wnt to change the display of the existing number?

To change the display of the existing number, use a custom number format
(select the cell, press Ctrl-1, choose the Number tab and Custom, then type
this into the Type edit box:

£#,##0.00,,;(£#,##0.00,,;)



"PricklyFlower" wrote:

Hi there, can anyone help me?

If I've got a figure in a spreadsheet, say £5,678,123 and I want this figure
to be shown as £5.68 (as in £5.68 million), is there an easy way of entering
a formula to do this automatically? The figures don't have to be numeric,
they can be as text.

Many thanks.

$0,,.# will be more to what you are looking for, the other format will not
round enough.

BJD

--
Message posted via http://www.officekb.com

Many thanks!

"bjd via OfficeKB.com" wrote:

$0,,.# will be more to what you are looking for, the other format will not
round enough.

BJD

--
Message posted via http://www.officekb.com

Thank you!

"Duke Carey" wrote:

Do you simply wnt to change the display of the existing number?

To change the display of the existing number, use a custom number format
(select the cell, press Ctrl-1, choose the Number tab and Custom, then type
this into the Type edit box:

£#,##0.00,,;(£#,##0.00,,;)



"PricklyFlower" wrote:

Hi there, can anyone help me?

If I've got a figure in a spreadsheet, say £5,678,123 and I want this figure
to be shown as £5.68 (as in £5.68 million), is there an easy way of entering
a formula to do this automatically? The figures don't have to be numeric,
they can be as text.

Many thanks.