Hi,

I'm creating a report where all the source numbers are negative but i'd like to show them as positive. Also given that they vary in value so greatly i'd like to format any numbers less than -1,000,000 to the nearest thousand (£#,##0.0,"k") and any numbers greater than -1,000,000 to the nearest million (£#,##0.0,,"m").

I've asked a similar query in the past here: http://www.excelforum.com/excel-gene...mat-query.html
but i'm struggling to adapt that to my current needs?

Any suggestions?!?!

Thanks

Snook