<div>
Unless there is a format that can mask the value, it can't be one value and display another. You may have to hide the column containing the true values and then create another column with the ROUND() function. In you example, it would be =round(a1,-5). There is also roundup and rounddown if you always want it to round up or down, respectively.
</div>


Unless there is a format that can mask the value, it can't be one value and display another. You may have to hide the column containing the true values and then create another column with the ROUND() function. In you example, it would be =round(a1,-5). There is also roundup and rounddown if you always want it to round up or down, respectively.

<div>
To do millions, you can use a custom format like this: &nbsp; #,,&quot;,000,000&quot;<br />
<br />
Your question asks millions, but your example displays 100,000s. &nbsp;Not sure how to do that.<br />
<br />
Dave
</div>


To do millions, you can use a custom format like this:   #,,",000,000"

Your question asks millions, but your example displays 100,000s.  Not sure how to do that.

Dave

<div>
I still not able to display 1,200,000 from 1,234,567<br />
<br />
How do I request attention to this question?
</div>


I still not able to display 1,200,000 from 1,234,567

How do I request attention to this question?

<div>
<div class="content wysiwyg-content">
Do you know how to customize in Excel to format a number in millions. &nbsp; For example, I want to format (not round) the number 1,234,567 to 1,200,000. &nbsp; <br />
<br />
I don't want the actual number to round or truncate.
</div>
</div>


Do you know how to customize in Excel to format a number in millions.   For example, I want to format (not round) the number 1,234,567 to 1,200,000.   

I don't want the actual number to round or truncate.

Excel - format number

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.