![]() |
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