Rounding

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Sorry..I forgot to tell you to go to format, custom, then add the format I
outlined.

Brian
 
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,,;)
 
$0,,.# will be more to what you are looking for, the other format will not
round enough.

BJD
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Distribution of capital contribution 4
Excel Stop Excel from displaying rounded values 4
Rounding data entered as Millions, how to please 3
Dynamic page WITHOUT leaving white space 1
Yet another question about my timesheet 3
rounding figures to nearest thousand 3
Rounding Formula 3
Rounding value in place 2

Back
Top