well, advanced to me anyway....thanks all for giving this a shot:
I have big dollar values in my data which will appear in the labels; some will be in the hundreds of thousands, some will be in the millions. I've been asked to label then with suffixes depending on their amount:
$945728.73 should appear as $946M (in the hundreds of thousands)
$1726538.34 should appear as $1.7MM (in the millions)
I'm ok with simple vb label rounding, ie. round(value,2), easy, but I'm way out of my depth with this new one, can anyone guide me?