Number Formating
Posted by Agraham on November 02, 2001 6:47 AM
I have a very large, 2D list of numbers that I am graphing(in format of $XX,XXX,XXX). Is it possible to create a number format that would list in millions (i.e., $XXM) without creating a new 2D of the numbers that I manually divide each number by 1M?
Posted by lenze on November 02, 2001 7:10 AM
Use Format>Numbers>Custom
Enter ##,, "M" in the type field
This will display 45378944 as 45 M and 4589734 as 46 M
Posted by IML on November 02, 2001 7:11 AM
You could try applying this format to your list
$##.0,,
good luck
Posted by Agraham on November 02, 2001 7:14 AM
That did it - Thanks!
