+ Reply to Thread
Results 1 to 3 of 3

About Custom Format Cell Number

  1. #1
    Forum Contributor BlastRanger's Avatar
    Join Date
    09-02-2010
    Location
    Indonesia
    MS-Off Ver
    2003, 2007, 2010
    Posts
    238

    About Custom Format Cell Number

    Hi all,
    I'm pretty confused about the custom section of Format Cell Number.
    Below is the custom code I get from, when I select category accounting Rp.
    _([$Rp-421]* #,##0_);_([$Rp-421]* (#,##0);_([$Rp-421]* "-"_);_(@_)

    Can somebody tell me why in order to format a number into Currency with aligned space for Currency symbol and the amount need to use that code in custom?
    Anyone can give me knowledge about custom number format so I can understand and in future will know what I want and how to code.

    Now, the solution I need urgently is how to custom format that code, so when a 0 (Zero) is entered into a cell, the cell display blank and not Rp. -

    Thank you
    Last edited by BlastRanger; 09-08-2010 at 02:56 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: About Custom Format Cell Number

    a few ref. links re: Custom Formats

    http://pubs.logicalexpressions.com/p...cle.asp?ID=414
    http://www.ozgrid.com/Excel/CustomFormats.htm
    http://simoncpage.co.uk/blog/2008/09...er-formatting/

    If you want blank rather than "Rp. -" for 0 values then clear the 0 format accordingly - all will become clear if you read through the above links.

  3. #3
    Forum Contributor BlastRanger's Avatar
    Join Date
    09-02-2010
    Location
    Indonesia
    MS-Off Ver
    2003, 2007, 2010
    Posts
    238

    Re: About Custom Format Cell Number

    Thank You again.
    Problem solved
    Will read carefully when I have some spare time. .

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1