| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage rounding error in charts | Excel Discussion (Misc queries) | |||
| Rounding Numbers | Excel Discussion (Misc queries) | |||
| Rounding numbers to the nearest thousand | Excel Discussion (Misc queries) | |||
| Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
| How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
Hybrid Mode
