Philippine Peso Symbol

You can get Philippine Peso symbol by typing "20b1" (without the quotes) and then press the Alt and X buttons simultaneously

It does not work in these forums, but does work in Word.

If you have the Philippines National Keyboard layout, you can also insert it by using the Right Alt key+p

See http://jcsesecuneta.com/tome/labox/philippines-national-keyboard-layout-now-available-for-windows/

Hello! Thank you very much for your reply. What I meant was the automatic formatting of the numbers in Excel.  Sorry, I should've been more specific. ^_^ 

I'll edit now my entry. :)

In Excel you have to type the number in the cell and then format the cell with the appropriate number format.

There is a predefined number format in Excel for the English Philippine Peso:

[$₱-3409]#,##0.00

Or maybe you mean "Filipino"

[$₱-464]#,##0.00

And you can have (almost) any currency format used around the world, the syntax for currency formats of cells is

"[$" & Currency Symbol & "-" & Language ID in hex & "]" & usual number format

Sub Test()
  Dim LanguageID As Long
  Dim CurrencyASCII As Long
  CurrencyASCII = 8369 'The sign in ASCII code
  LanguageID = 13321 'The language id (3409 in hex)
  ActiveCell.NumberFormat = _
    "[$" & ChrW(CurrencyASCII) & "-" & Hex(LanguageID) & "]#,##0.00"
End Sub

Execute that and look into the cell format.

You can also apply that with a formula:
=TEXT(1,"[$₱-3409]#.##0,00")

Andreas.

I guess, I need to do it the hard way for now.  :(

You have misunderstood me, you just have to format the cell with the appropriate format:

After you have formatted the cell once, open the Format Cells window again and choose Custom, then you can see what I have described above.

Andreas.