ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Custom Format: Number * 1000000 (https://www.excelbanter.com/excel-programming/369339-custom-format-number-%2A-1000000-a.html)

Damian Carrillo[_3_]

Custom Format: Number * 1000000
 
I've seen lots of people answering questions regarding how to divide a
number in cell A2 like $12,200,000.00 by a million so it appears as
$12.2M and the like. Now I'm wondering if it is possible to do the
opposite. Instead of changing the format to hide zeroes, is it
possible to instead add them? If I have the number 12.2 in cell A2, is
it possible to make a custom number format mask that makes the value
appear as $12,200,000.00 instead?

Damian



All times are GMT +1. The time now is 11:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com