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