Existing numeric formatting options allow us to choose the number of decimal places required, but this often depends on scale - if I'm looking at sales of one item in one week in one store, I probably want to see cash value in pounds and pence, but if I am looking at total revenue for the last financal year, then I may well want to see just thousands of pounds (typical financial/management reporting).

Would it be possible to allow the user to choose "significant figures" (reminds me of O-level maths, showing my age!) e.g. 5-significant figures would show:

£4.99 = £4.99
£134.59 = £134.59
£23,456.97 = £23,456
£3,457,487.42 = £3,457,500

Better still would the some form of 'scale' format e.g. <£100 show 2dp, £100 - £10,000 round to nearest pound, £10,000+ round to nearest thousand.<br />
Just a thought...