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
Bookmarks