Rounding

P

PricklyFlower

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.
 
B

bjd via OfficeKB.com

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

Brian
 
D

Duke Carey

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,,;)
 
B

bjd via OfficeKB.com

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

BJD
 
P

Pricklyflower

Thank you!

Duke Carey said:
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,,;)
Click to expand...
 
Top