View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Damian Carrillo[_3_] Damian Carrillo[_3_] is offline
external usenet poster
 
Posts: 19
Default 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