| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Rounding
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. |
| 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) | |||
Threaded Mode
