How do I display large numbers in millions?

[#1]

I have a table box where I would like one field to display numbers in millions, i.e. turn 3,400,000 into $3.4M. How do I do this?

Thanks!

[swuehl]

Maybe like shown here:

dynamically changing scale in text box

[#3]

Have you tried doing anything with the num() function?

[#4]

Divide your expression by 1,000,000. Then:

Chart Properties -> Number -> Make the million symbol M