Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
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?
Re: Number Formating
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
Re: Number Formating
Posted by IML on November 02, 2001 7:11 AM
You could try applying this format to your list
$##.0,,
good luck
Re: Number Formating
Posted by Agraham on November 02, 2001 7:14 AM
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.